SQL-How to list out all tables in SQL server database

To list out all tables in SQL server database using SQL query


SELECT TABLE_NAME FROM <databasename>.INFORMATION_SCHEMA.Tables WHERE TABLE_TYPE = 'BASE TABLE'

example using Northwind Database:

SELECT TABLE_NAME FROM Northwind.INFORMATION_SCHEMA.Tables WHERE TABLE_TYPE = 'BASE TABLE'