Help Center> Data Lake Insight> SQL Syntax Reference (To Be Offline)> Flink OpenSource SQL 1.12 Syntax Reference> Constraints and Definitions> Syntax> Data Definition Language (DDL)> CREATE VIEW
Updated on 2023-03-17 GMT+08:00
View PDF

CREATE VIEW

Syntax

CREATE VIEW [IF NOT EXISTS] view_name
  [{columnName [, columnName ]* }] [COMMENT view_comment]
  AS query_expression

Function

Create a view with multiple layers nested in it to simplify the development process.

Description

IF NOT EXISTS

If the view already exists, nothing happens.

Example

Create a view named viewName.

create view viewName as select * from dataSource