SHOW TABLES
Function
SHOW TABLES command is used to list all tables in the current or a specific database.
Syntax
SHOW TABLES [IN db_name];
Parameter Description
| Parameter | Description |
|---|---|
| IN db_name | Name of the database. This parameter is required only when tables of this specific database are to be listed. |
Usage Guidelines
IN db_Name is optional.
Examples
SHOW TABLES IN ProductDatabase;
System Response
All tables are listed.
Last Article: DROP TABLE
Next Article: ALTER TABLE COMPACTION
Did this article solve your problem?
Thank you for your score!Your feedback would help us improve the website.