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 image](https://abundantcode.com/wp-content/uploads/2016/08/image_thumb-26.png)
Leave a Reply