Skip to main content

View definitions

Regular view specifications are supported.

view_def:
    CREATE [ OR REPLACE ] VIEW view_name  [ '(' column_name [ ',' ...')' ] ]
           AS select_query_without_limit
           [ WITH CHECK OPTION ]

A view can be seen as a stored SELECT query. It is useful to reduce query complexity as it can include joins, unions and aggregations, increase standardisation and reusability and support server-based reporting.

Note: Recursive views and reference-able views are not supported.

Note: You can't insert, update, delete or truncate data from a view. Updatable views are not supported.