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.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.