Getting List of MS SQL User-Created Tables

26 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

How is Change Tracking is Different From Change Data Capture ?

Using MS SQL COUNT

What is Auditing Inside SQL Server ?

What is TABLESAMPLE in SQL Server ?

What is Change Data Capture in SQL Server ?