How to get the list of Tables in an particular DataBase:

Posted by Sathya4260 under Sql Server category on | Points: 40 | Views : 2397

Here is the simple codes to get the list of tables present in the Database

FROM DBName.sys.tables;

To the get the Tables count in the DB

SELECT Count(*)
FROM DBName.sys.tables;

By default we can find the created date of all tables also

SELECT name,Create_Date
FROM DBName.sys.tables;

Comments or Responses

Login to post response