Hi,
Can't find the answer so far, so it's up to you!
How can I determine when an index was created? (non-clustered or clustered)
Is must be somewhere, because aquafold is able to represent this information (see here)
Thanks!
asked
When was index created?
Take a look at sys.objects. That will show you information like the create date for an index.
You can't find out the creation date for all indexes. You can find out the creation date for the indexes that enforce PRIMARY KEY and UNIQUE constraints by looking either in sys.objects or sys.key_constraints at the create_date column.
However, for normal referential indexes that aren't part of a key constraint, you cannot find the creation time.
