SHOW VIEWS
Last updated: 2024-08-07 17:22:25
Description
Supported engines: Presto and SparkSQL
Purpose: List views in the specified database. If the database name is not specified, views in the current database are listed.
Statement
SHOW VIEWS [IN database_name] LIKE ['regular_expression']
Parameter
[IN database_name]: Name of the database whose views are to be listed. If this parameter is left blank, the database in the current context is selected.regular_expression: Regular expression for filtering matching views Only the wildcard character * representing any character or expressions representing spaces or special characters between normal characters can be used.Example
SHOW VIEWS;SHOW VIEWS IN db01 LIKE 'view*';
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No
Feedback