How to get the index creation date in SQL Server?

Asked

Viewed 2,614 times

3

By SQL Server Management Studio I did not find in the properties of an index its creation date.

How can I get the creation date of a specific index by just referring by name?

sql-server tsql índices

2 answers

5


For the documentation of Microsoft SQL Server - sys.Indexes (English), there is no field that stores the creation date of Index.

A survey (English) on the Microsoft SQL Server website itself reveals that this information is not stored anywhere, that only through a trace created by you you can keep up with that information.

For cases where the index is also PK or UQ, the closest you actually have is the creation date of that object in the sysobjects (English), more precisely the field crdate.

On other SE sites the same question has already been asked during these years and so far the answer is that it is not possible:

-2

I’m without MSSQL here, but try this.

 SELECT CREATE_DATE FROM SYS.INDEXES I
 INNER JOIN SYS.OBJECTS O ON I.OBJECT_ID = O.OBJECT_ID
 WHERE I.NAME = 'NOME_DO_INDICE'

Browser other questions tagged sql-server tsql índices

You are not signed in. Login or sign up in order to post.