Database object creation Dates

  • Can anyone tell me how I can find out when an Index was created on a table 

  • select * from sysobjects where type='K'

    look in field crdate and the name of your index.

    in the sample K means primary key.

  • 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