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.