Getting List of MS SQL User-Created Tables

185 Reads Ms Sql

To get a list of all tables created by user(s) in a database in MS SQL Server, the following query should be run.

SELECT NAME FROM sys.objects WHERE TYPE='U'
Ms Sql

You May Interest

What is The Concept of Piecemeal Restore on SQL Server ?

MS SQL List of Records in All Tables

Benefits of Using Stored Procedures in MS SQL

When Will You Use SQLDiag Tool ?

Using MS SQL TOP