Get all tables in a database

‘SHOW TABLES’ command gives you all the tables information.

mysql> USE sample;
Database changed
mysql>
mysql> SHOW TABLES;
+-------------------+
| Tables_in_sample  |
+-------------------+
| employee          |
| employee_name_dob |
+-------------------+
2 rows in set (0.00 sec)
  
mysql>

Previous                                                 Next                                                 Home