CREATE VIEW statement that defines each view.
For more information regarding views, see information_schema.views.
Syntax
Returns
The returned table has the following columns.| Column name | Data Type | Description |
|---|---|---|
| view_name | TEXT | The name of the view. |
| view_definition | TEXT | The query statement that defines the view. |
Example
The following example displays the view name and view definition of a views in the database queried: Returns:| view_name | schema |
|---|---|
| v14 | CREATE VIEW “v14” AS SELECT a.* FROM (SELECT 1 AS “x”) AS “a” INNER JOIN (SELECT 1 AS “x”) AS “b” USING(x) |
| v15 | CREATE VIEW IF NOT EXISTS “v15” AS SELECT * FROM “bf_test_t” WHERE ( “n” = 0 ) |
| v16 | CREATE VIEW “v16” AS WITH x7 AS (SELECT _ FROM “oz_x6” ) SELECT _ FROM “x7” |