Lists all the base tables and views in a database.
Note
The StatementType parameter for SHOW TABLES in GetQueryExecution API operation is categorized as UTILITY, not
DDL.
Synopsis
SHOW TABLES [IN database_name] ['regular_expression']Parameters
- [IN database_name]
-
Specifies the
database_namefrom which tables will be listed. If omitted, the database from the current context is assumed.Note
SHOW TABLESmay fail ifdatabase_nameuses an unsupported character such as a hyphen. As a workaround, try enclosing the database name in backticks. - ['regular_expression']
-
Filters the list of tables to those that match the
regular_expressionyou specify. To indicate any character inAWSDataCatalogtables, you can use the*or.*wildcard expression. For Apache Hive databases, use the.*wildcard expression. To indicate a choice between characters, use the|character.
Examples
Example – Show all of the tables in the database sampledb
SHOW TABLES IN sampledbResults
alb_logs cloudfront_logs elb_logs flights_2016 flights_parquet view_2016_flights_dfw
Example – Show the names of all tables in sampledb that include the
word "flights"
SHOW TABLES IN sampledb '*flights*'Results
flights_2016 flights_parquet view_2016_flights_dfw
Example – Show the names of all tables in sampledb that end in the
word "logs"
SHOW TABLES IN sampledb '*logs'Results
alb_logs cloudfront_logs elb_logs
