Getting List of MS SQL User-Created Tables

201 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 Log Shipping in SQL Server ?

MS SQL Getting List of All Column Names of a Table

Changing MS SQL Database Name with Query

What is CTE in SQL Server ?

Disabling All Constants in a Table in MS SQL