Syntax
The CREATE VIEW statement has the following format:
[EXEC SQL] CREATE VIEW view_name
[(column_name {, column_name})]
AS select_stmt
[WITH CHECK OPTION]
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.
Prevents an INSERT or UPDATE to a view that creates a row that does not comply with the view definition.