SHOW VIEWS

Lists the views defined in the current database and the CREATE VIEW statement that defines each view.

Syntax

SHOW VIEWS;

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”

⌘I