In this post, we will discuss how to get all user-defined tables in sql server 2008.
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:
Download FREE SharePoint 2019 Installation PDF Guide
This FREE PDF contains, Steps by step guide to install SharePoint 2019 Preview, prerequisites, hardware and software new features. First impression to SharePoint Server 2019 new modern site, modern lists and modern document libraries.
You May Also like the Following SharePoint Online Tutorials: