How to get the all user created tables saved in ms sql server database

In this programming tutorial you will learn how to get the all user created tables saved in ms sql server database. It is quite easy and simple. Only you have to do is to write and execute the following query.

How to get all user created tables saved in ms sql server database

SELECT * FROM SYS.OBJECTS WHERE TYPE ='u'

The above mentioned query will return you the all user created tables saved in ms sql server database. User created tables means the tables created by users, not the built-in system tables. Sys.Objects is a built-in table in ms sql server that has information about each and every element of the database.

I love your feedback.