Getting List of MS SQL User-Created Tables

8 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

MS SQL Compiling a Stored Procedure With a Requery

Which TCP/IP Port Does the SQL Server Run On ?

Using Trim Function in MS SQL

How is Deadlock Different From a Blocking Situation in SQL Server ...

Where are SQL Server Usernames and Passwords Stored in the SQL Se ...