SQL All Tables

SQL All Tables is used to show all the tables in database.

SQL All Tables

SQL All Tables

     

SQL All Tables is used to show all the tables in database.

Understand with Example

The Tutorial illustrate an example from 'SQL All Tables'. To understand and grasp the example we use query show tables that is used is show the tables in database 'komal'.

show tables : This is used to show the list of tables in database.

 

Query

mysql> show tables;
+-----------------+
| Tables_in_komal |
+-----------------+
| emp             |
| lib             |
| stu             |
| stu1            |
+-----------------+
4 rows in set (0.00 sec)