Look at the following query; it will fetch all the tables in your database using the Query.
use ABC --here ABC is database Name
select distinct TABLE_NAME from INFORMATION_SCHEMA .TABLES
DataBase Table in SQL server
Here, we will see how to find out about all the tables in my database, in the SQL Server.
Join the conversation! Your thoughts help the community grow.