SHOW TABLES [IN database_name] ['regular_expression']
[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.SHOW TABLES IN sampledb;
SHOW TABLES IN sampledb '*flights*';
Was this page helpful?
You can also Contact sales or Submit a Ticket for help.
Help us improve! Rate your documentation experience in 5 mins.
Feedback