Link Search Menu Expand Document

This documentation is related to an older version of Firebolt. For the most current documentation, see Firebolt documentation.

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”