Get All Table names from SQL Server Database

In this article, I will explain how to get all table names from SQL Server Database. The below mentioned query will list all the table names available in the database.

select Table_Catalog, Table_Schema, Table_Name, Table_Type
  from information_schema.tables 
where Table_Type = 'BASE TABLE' order by Table_Name

In the above sample, Table_Catalog is the Database Name, Table_Name is the table name.

The mentioned below is the output for the above query.

Result for SQL Query