Find out what tables the current database contains : Current Table « Table Index « SQL / MySQL

1. SQL / MySQL
2. Table Index
3. Current Table

Find out what tables the current database contains

  
/*
mysql> SHOW TABLES;
+----------------+
| Tables_in_info |
+----------------+
| bird           |
| cloth          |
| course         |
| employee       |
| event          |
| exam           |
| myusers        |
| report         |
| timetable      |
| users          |
+----------------+
10 rows in set (0.00 sec)


*/

SHOW TABLES;

           
       

Related examples in the same category