Microsoft SQL Server How To: Get a List of all Tables in a Database
1 min readAug 3, 2020
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