Getting List of MS SQL User-Created Tables

193 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 Central Management in SQL Server ?

Changing Column Name of MS SQL Table with Query

What is the Difference Between Update Lock and Exclusive Lock in ...

What are Replication and Database Mirroring in SQL Server ?

What are the Different Recovery Models Inside SQL Server ?