Database object creation Dates

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Deni Kusdeni Default port Points: 1457 More actions · Answer 1

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 More actions · Answer 2

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