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

AbundantCode 3 months ago in SQL Server 0

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
Tags : , , , , 

Leave Your Comment