CREATE VIEW statement

The CREATE VIEW statement creates a new database view. A view is effectively a SQL query stored in the catalog.

Syntax

CREATE VIEW view_name [(column_name, [, …])] AS <select_statement>

Remarks

View_name must be fully qualified, that is, catalog.schema.name.

View metadata is stored in the AF Configuration Database; therefore, PI Servers without an AF Configuration Database do not support creation of views.