Wednesday, November 11, 2009

How to get tables names in MySql (sysobjects in sql server)

1 comment
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.

Syntax
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

SHOW TABLES

And click on Run.

It will show all the tables which is avalible in the list

1 comments:

Shakti Singh Dulawat said...

Finally you change logo and you have 34 reader now that great news
keep up good work