Search - Articles
DevASP.NET for ASP.NET, VB.NET, XML and C# (C-Sharp) Developers Tuesday, March 03, 2009
Dev Articles
Search Directory
SQL Server

Get table create and last modify date time using PL-SQL in SQL server 2008.

Author: Zunnair

In this simple article you will learn that how you can get table create and last modify date time using PL SQL

In sql server 2008 we can check created and modified date time of table using simple query in PL-SQL




Select name as 'Table Name', create_date as 'Creation Date', modify_dateas 'Modification Date' from sys.objects

where type_desc= 'USER_TABLE'



Table Name    Creation Date                                                Modification Date

Login       2008-09-18 12:38:47.840             2008-09-18 12:38:47.843

Users       2008-09-18 12:38:47.840             2008-09-18 12:38:47.843

Settings    2008-09-18 12:38:47.840             2008-09-18 12:38:47.843

Roles       2008-09-18 12:38:47.840             2008-09-18 12:38:47.843

Customers   2008-09-18 12:38:47.840             2008-09-18 12:38:47.847



Using this functionality we can easily get creation and modification date of table created by any user in any database.

Article Comments
Can we find the last modification date of change in values of a table in SQL Server??

Posted on 1/29/2010 5:42:11 AM by sheena

Add Article Comment:
Name :
Email Address :
Comments :
<< Working with new data type TIME introduced in SQL Server 2008. (SQL Server new features)

Disclaimer - Privacy
© 2002-2017