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

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;