SHOW VIEWS

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

Syntax

SHOW VIEWS;

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”