SHOW TABLES
Last updated: 2024-08-07 17:12:50
Description
Supported engines: Presto and SparkSQL
Applicable table: Native and external tables
Purpose: List all base tables and views in the database.
Statement
SHOW TABLES [IN database_name] ['regular_expression']
Parameter
[IN database_name]: Name of the database whose tables 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 tables Only the wildcard character * representing any character or expressions representing spaces or special characters between normal characters can be used.Example
SHOW TABLES IN sampledb;
SHOW TABLES IN sampledb '*flights*';
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No
Feedback