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

Sathya4260
Posted by Sathya4260 under Sql Server category on | Points: 40 | Views : 2502
Hi,

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

SELECT name
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