12/27/2023 0 Comments Tabular view![]() This parameter may be either local or cascaded, and is equivalent to specifying WITH CHECK OPTION (see below). This clause specifies optional parameters for a view the following parameters are supported: If not given, the column names are deduced from the query. column_nameĪn optional list of names to be used for columns of the view. The name (optionally schema-qualified) of a view to be created. ) SELECT column_names FROM view_name Ī view column name list must be specified for a recursive view. ĬREATE VIEW view_name AS WITH RECURSIVE view_name ( column_names) AS (SELECT. RECURSIVEĬREATE RECURSIVE VIEW view_name ( column_names) AS SELECT. If any of the tables referenced by the view are temporary, the view is created as a temporary view (whether TEMPORARY is specified or not). Existing permanent relations with the same name are not visible to the current session while the temporary view exists, unless they are referenced with schema-qualified names. Temporary views are automatically dropped at the end of the current session. If specified, the view is created as a temporary view. The name of the view must be distinct from the name of any other relation (table, sequence, index, view, materialized view, or foreign table) in the same schema. Temporary views exist in a special schema, so a schema name cannot be given when creating a temporary view. Otherwise it is created in the current schema. ) then the view is created in the specified schema. If a schema name is given (for example, CREATE VIEW myschema.myview. The calculations giving rise to the output columns may be completely different. The new query must generate the same columns that were generated by the existing view query (that is, the same column names in the same order and with the same data types), but it may add additional columns to the end of the list. Instead, the query is run every time the view is referenced in a query.ĬREATE OR REPLACE VIEW is similar, but if a view of the same name already exists, it is replaced.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |