Getting List of MS SQL User-Created Tables

211 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

Listing Metadata of MS SQL Server Internal Tables

Using MS SQL Order By

MS SQL List of Records in All Tables

What is Blocking in SQL Server ?

Finding Session Id in MS SQL User's Current Process