Paul Pennock
Ten Centuries
Points: 1091
More actions
October 14, 2005 at 3:56 am
#89483
Can anyone tell me how I can find out when an Index was created on a table
Deni Kusdeni
Default port
Points: 1457
October 14, 2005 at 4:35 am
#597299
select * from sysobjects where type='K'
look in field crdate and the name of your index.
in the sample K means primary key.
Clive Strong
SSChampion
Points: 11222
October 14, 2005 at 4:44 am
#597300
This code should help.
select so.name as [Table Name], si.name as [Index Name], so.crdate as [Create Date]
from sysobjects so inner join sysindexes si
on so.id = si.id
order by so.name, si.indid
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply