SHOW VIEWS

Display all views which 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] - same matching rules as SHOW TABLES, restricted to database objects of type VIEW.

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 4.9.8.