SHOW VIEWS

Core command SH VI SHVI

Displays all views whose schema and name match the entered pattern

Arguments

<viewName> (optional) a schema and name separated by a dot(.). Schema name is optional

Examples

SHOW VIEWS;
SHOW VIEWS CUSTOMER;
SHOW VIEWS CUSTOM%;
SHOW VIEWS PUBLIC.CUSTOMER;
SHOW VIEWS PUB%.CUSTOMER;
SHOW VIEWS PUB%.%STOME%;

Notes

Lists views matching a pattern: SHOW VIEWS [[schema.]namePattern], with the same matching rules as SHOW TABLES. Views are listed here and never by SHOW TABLES. Materialized views are listed too, on databases that have them (PostgreSQL). Synonyms are listed by neither command.

Both the schema and view-name parts (separated by a dot, schema optional) are always treated as a "contains" search - each is internally wrapped in %...%. If the view-name part is omitted, all views are listed; if the schema part is omitted, the search is restricted to the connection's <em>current</em> schema, not every schema.

Last modified in release 5.3.2.