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.v3
.
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.