Pages

Sunday, August 12, 2012

table create date in SQL Server

Find out the Table create date in SQL Server


Below query will help in finding out the creation date of the tables in a particular database of SQL Server

Use DBNAME
Go
select
i.name,i.object_id,o.create_date,o.object_id,o.name from sys.indexes i join sys.objects o on i.object_id=o.object_id where i.name='tablename'