To view the tables you have created in a database, first select the database using the USE database_name; command.
Then, type SHOW TABLES; to display the list of tables in that database.
Syntax:
USE database_name;
SHOW TABLES;
To view the tables you have created in a database, first select the database using the USE database_name; command.
Then, type SHOW TABLES; to display the list of tables in that database.
Syntax:
USE database_name;
SHOW TABLES;