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

FREE 12 month online training for ASP.NET & MS Expression Studio and a Free copy of MS Expression Web with Windows Server Purchase
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

 

Query:

 

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

where type_desc= 'USER_TABLE'

 

Results:

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-2014 DevASP.net