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
How to get tables names in MySql (sysobjects in sql server)
An IT Solution is a purpose and value-driven organization where everyone is empowered to take decisions in line with our culture. We provide a unique environment of freedom, flexibility & trust that allows an individuals potentials to flower; this results in tremendous growth opportunities.Such a culture, naturally, appeals to everyone. We listen, we think and we act. The IT field is all about thought leadership. We invest in thought for you as customers
1 comment:
Finally you change logo and you have 34 reader now that great news
keep up good work
Post a Comment