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'
Recent Stories
-
Set up dbt for Fabric SQL Database (Nandan Hegde) c-sharpcorner.com
-
Indexing SQL Server Queries For Performance: Indexed Views And Filtered... youtube.com
-
Resetting Identity Seed in SQL Server After Deleting Records (Chris... pietschsoft.com
-
TortoiseSVN + Assembla Cloud Repos: A Guide to Modern, Reliable... get.assembla.com
-
Deploy DeepSeek models locally and monitor with New Relic AI... newrelic.com
Leave Your Comment