Sometimes we need to find table list present in a database so that we can identify which table we have to create and which one not.
To work in a particular database we need to use the below statement first:
use database_name;
Example:
use demo;
the above statement brings you inside the "demo" database.
then use the below statement:
show tables;
the above statement will list all the tables in the "demo" database.
Hope this will help you :)
0 Comment(s)