Getting List of MS SQL User-Created Tables

49 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

Getting List of All Stored Procedures in Database in MS SQL

What are Table Valued Parameters ?

MS SQL Get Current Time GETDATE()

MS SQL Restoring a Database With a Query

What is CHECKPOINT Process in the SQL Server ?