Post reply

object creation dates

  • October 14, 2005 at 4:23 am

    #115309

    does anyone know how I can find out when an Index was added to a database? 

  • October 14, 2005 at 4:35 am

    #597298

    select * from sysobjects where type='K'

    look in field crdate and the name of your index.

    in the sample K means primary key.

  • October 15, 2005 at 3:29 am

    #597497

    Hii!!!!

    U can modified like this also!!!!

    SELECT S.NAME TABLE_NAME,P.INDEX_NAME,P.CREATED_DATE FROM SYSOBJECTS S INNER JOIN (SELECT TOP 100 PERCENT NAME INDEX_NAME,PARENT_OBJ,TYPE,CRDATE CREATED_DATE FROM SYSOBJECTS ORDER BY 1) P

    ON S.ID = P.PARENT_OBJ

    WHERE P.TYPE = 'K' AND S.NAME = 'Table_Name'

    Regards,

    Papillon

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

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