SHOW TABLE¶
Function¶
This command is used to display all tables in current database or all tables in a specific database.
Syntax¶
SHOW TABLES [IN db_name];
Parameter Description¶
Parameter | Description |
|---|---|
IN db_name | Name of the specific database whose tables need to be all displayed. |
Precautions¶
IN db_Name is optional. It is required only when you need to display all tables of a specific database.
Examples¶
SHOW TABLES IN hudidb;
System Response¶
All tables are listed.