• For indices other than primary keys the answer is NO, the closest would be the date for the statistics

    😎

    SELECT

    I.object_id

    ,I.index_id

    ,I.name AS IDX_NAME

    ,OBJECT_NAME(I.object_id) AS OBJ_NAME

    ,STATS_DATE(I.object_id, I.index_id) AS IDX_STATS_DATE

    FROM sys.indexes I

    WHERE STATS_DATE(I.object_id, I.index_id) IS NOT NULL;