Help Center/ Data Lake Insight/ Flink SQL Syntax Reference/ Flink OpenSource SQL 1.12 Syntax Reference/ Constraints and Definitions/ Syntax/ Data Definition Language (DDL)/ CREATE VIEW
Updated on 2022-09-15 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