Get all user defined tables in SQL Server 2008

In this post, we will discuss how to get all user-defined tables in sql server 2008.

New to Office 365 SharePoint Online? Get Office 365 Enterprise E3 Subscription & Try out all the features

You can also check my previous posts on Some Optimization Tips in sql server, Left outer join and Right outer join in SQL Server and Difference between a clustered index and non clustered index in sql server 2008.

Below is the query that will retrieve user-defined tables from the database.

SELECT name AS [TableName] FROM sys.objects where type_desc = ‘USER_TABLE’


SELECT name FROM sys.objects WHERE type = ‘u’

See the figure for output:

Similarly you can also get the modified date like below:

SELECT name AS [TableName],modify_date as [ModifyDate] FROM sys.objects where type_desc = ‘USER_TABLE’

Also, you can check out my previous posts on:

Tutorial on Testing Measurement and Metrics

Top-Down and Bottom-up Approach in Integration Testing

Selenium interview questions and answers

Check out Best Alternative to InfoPath -> Try Now


(Installation & Features)

About Bijay Kumar

I am Bijay from Odisha, India. Currently working in my own venture TSInfo Technologies in Bangalore, India. I am Microsoft Office Servers and Services (SharePoint) MVP (5 times). I works in SharePoint 2016/2013/2010, SharePoint Online Office 365 etc. Check out My MVP Profile.. I also run popular SharePoint web site

View all posts by Bijay Kumar →