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