Thread: How to Get Table List - MS SQL

How to Get Table List - MS SQL
Very simple. On management studio run this query.

Code:

select * FROM  INFORMATION_SCHEMA.TABLES

Thanks Manik for this query.......

thank you that you shared the your Experience..

thanks a lot

Hi thank for sharing....
sp_tables returns a list of tables and views that can be queried in a selected database. The basic usage is as follows:
sp_tables [ [ @table_name = ] 'name' ]
[ , [ @table_owner = ] 'owner' ]
[ , [ @table_qualifier = ] 'qualifier' ]
[ , [ @table_type = ] "type" ]
[ , [@fUsePattern = ] 'fUsePattern'];

In my point of view you can use the following SQL table:
SELECT name [Table Name]

FROM sysobjects

WHERE xtype = 'YOU'

thank u very much....

thanks.. but is there a way to do that in codes..?

I think you may used the query in mysql $sql = "select * from table name"; mysql_query is used to run the query..