Help Center/ Data Lake Insight/ SQL Syntax Reference (To Be Offline)/ Flink Opensource SQL 1.10 Syntax Reference/ Constraints and Definitions/ Syntax Definition/ Data Definition Language (DDL)/ CREATE VIEW
Updated on 2022-09-23 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