How to get the list of all tables from a SQL Server database ?

If you need to get the list of all tables from a SQL Server database , you can query the information_schema.tables by specifying the TABLE_TYPE parameter search criteria to “BASE TABLE’.

How to get the list of all tables from a SQL Server database ?

Use AdventureWorks2014 <br>GO <br>SELECT * FROM information_schema.tables WHERE TABLE_TYPE='BASE TABLE'
image