Post reply

Checking for Indexes on Temp table

  • August 25, 2006 at 10:32 am

    #62262

    Hi All,

    Does anyone know how to check for indexes on a temp table before dropping it, I know that on a proper table, the indexes can be checked from sysindexes.

    Can anyone help on this ?

    Kindest Regards,

    John Burchel (Trainee Developer)

  • August 25, 2006 at 12:09 pm

    #656899

    Did you check in tempdb.dbo.sysindexes?

  • August 25, 2006 at 4:45 pm

    #656974

    I done that, but the table is in sysindexes, even if the index has already been dropped. so it causes a bot of a problem

    Kindest Regards,

    John Burchel (Trainee Developer)

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

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