Return All Tables Name from a SQL Server Data Base

Here I am going to show how we can get All Tables Name from a SQL Server Data Base using a SQL Query.

SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE='BASE TABLE'

 

 

 

Image 1.