In Sql server we have a table sysobjects which holds names of all the tables i.e. system and user tables.
Like the same we have command “Show tables” which show all the tables of specified database.
Show Tables from <databasename>
Here is an example.
SHOW TABLES FROM MySql
If you had already select a database you can only use
Show tables to show all the tables in the database. For ex. Select database MySql and in Sql command window enter following text
And click on Run.
It will show all the tables which is avalible in the list