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'
