SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—523725-004
2-106
Syntax Description of CREATE VIEW
Syntax Description of CREATE VIEW
view
specifies the ANSI logical name for the view of the form:
[[catalog-name.]schema-name.]view
where each part of the name is a valid SQL identifier with a maximum of 128
characters. view must be unique among table, view, SQL/MP alias, and procedure
names in the schema. For information, see Identifiers on page 6-54.
(column-name [heading] [,column-name [heading]]...)
specifies names for the columns of the view and, optionally, headings for the
columns. Column names in the list must match one-for-one with columns in the
table specified by query-expr.
If you omit this clause, columns in the view have the same names as the
corresponding columns in query-expr. You must specify this clause if any two
columns in the table specified by query-expr have the same name or if any
column of that table does not have a name. For example, in the query expression
“SELECT MAX(salary), AVG(salary) AS average_salary FROM employee” the first
column does not have a name.
column-name
specifies the name for a column in the view. column-name is an SQL
identifier. column-name must be unique among column names in the view
and cannot be a reserved word. It can contain a reserved word if it is delimited.
If you do not specify this clause, columns in the view have the same names as
the columns in the select list of query-expr.
No two columns of the view can have the same name; if a view refers to more
than one table and the select list refers to columns from different tables with
the same name, you must specify new names for columns that would
otherwise have duplicate names.
HEADING 'heading-string' | NO HEADING
specifies a string heading-string of 0 to 128 characters to use as a
heading for the column if it is displayed by using a SELECT statement in MXCI.
The heading-string can contain characters only from the ISO88591
character set. The default heading is the column name. If you specify a
heading that is identical to the column name, INVOKE and SHOWDDL do not
display that heading.
If you specify NO HEADING or HEADING ‘’, NonStop SQL/MX stores this as
HEADING ‘’, and the column name is displayed as the heading in a SELECT
statement. The behavior for HEADING ‘’ is different from that of SQL/MP, which