≡ Menu




How to get Tables list in database TSQL

 

Main object is sys.tables. you can get all information about tables by query on sys.tables.

 

User databasename

Select * from sys.tables;.

 

 

SELECT SCHEMA_NAME(schema_id) AS table_schema_name, name AS table_Name

FROM  sys.tables;

 

 

SCHEMA_NAME convert  schema_id into schema name.

Comments on this entry are closed.