CREATE VIEW
Valid in: SQL, ESQL, OpenAPI, ODBC, JDBC, .NET
The CREATE VIEW statement defines a virtual table.
This statement has the following format:
CREATE VIEW view_name [(column_name {, column_name})] AS [WITH common_table_expression] select_stmt
view_name
Defines the name of the view. It must be a valid object name.
select_stmt
Is a SELECT statement, as described in the SELECT statement description in this chapter.