How to List all Tables in a SQL Server Database

To list all tables in a SQL Server Database, run the following code that checks the INFORMATION_SCHEMA.TABLES view:

USE Database_Name
SELECT * FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE ='BASE TABLE'

list_all_tables_in_a_database

Read related blog post:
How to check if the Table exists in a SQL Server Database