Commands
CREATE VIEW
Use the CREATE VIEW
command to create a non-materialized view, which runs every time the view is referenced in a query. A non-materialized view can be created based on sources, tables, views, or indexes.
Syntax
Parameters
Parameter | Description |
---|---|
mv_name | The name of the view to be created. |
column_name | Specify the columns of the view. |
select_query | A SELECT query that retrieves data for the view. See SELECT for the syntax and examples of the SELECT command. |
Examples
The following statements create views based a plain table and a table with connector settings, and then create a new view based on the existing views. The data for the table is generated by the built-in load generator.
Let’s query view v3
.
NOTE
Names and unquoted identifiers are case-insensitive. Therefore, you must double-quote any of these fields for them to be case-sensitive. See also Identifiers.
Was this page helpful?