Microsoft SQL Server How To: Get a List of all Tables in a Database
Microsoft SQL Server How To: Get a List of all Tables in a Database
SELECT TABLE_NAME FROM <DATABASE_NAME>.INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = ‘BASE TABLE’
Source: https://stackoverflow.com/questions/175415/how-do-i-get-list-of-all-tables-in-a-database-using-tsql