SHOW VIEWS

Lists the views defined in the current database and the CREATE VIEW statement that defines each view. For more information regarding views, see information_schema.views.

Syntax

SHOW VIEWS;

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”

SHOW TABLES

SQL functions

⌘I

Overview

Performance and Observability

Security

Self-Managed

Managed service

Guides

SQL reference

Release notes

API reference

Legal

Syntax

Returns

Example

​Syntax

​Returns

​Example

Syntax

Returns

Example