SHOW VIEWS
Lists the views defined in the current database and the CREATE VIEW statement (schema) that defines each view.
Syntax
SHOW VIEWS;
Example
SHOW VIEWS;
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” |