Syntax
The CREATE VIEW statement has the following format:
[EXEC SQL] CREATE VIEW view_name
[(column_name {, column_name})]
AS subselect {UNION [ALL] subselect}
[WITH with_clause]
view_name
Defines the name of the view. It must be a valid object name.
subselect
Specifies a SELECT clause, as described in the Select statement description in this chapter.
WITH with_clause
Specifies Enterprise Access product-specific options. For details,see your Enterprise Access product guide.For an overview of the Enterprise Access product WITH clause, see the chapter "OpenSQL Features."
Enterprise Access products that do not support the WITH CHECK OPTION will ignore it when creating the specified view.