SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE='BASE TABLE'
Image 1.
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'
Join the conversation! Your thoughts help the community grow.