Getting List of MS SQL User-Created Tables

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'


You May Interest

What is Log Shipping in SQL Server ?

What is the Filtered Index in SQL Server ?

Using CASE WHEN in MS SQL

MS SQL Getting a Random Row in a Table

How to Optimize Stored Procedure in SQL Server ?