Post reply

Truncate table and indexes

  • April 2, 2007 at 7:53 pm

    #119274

    Hi there,

    When the table is truncated, what happens to the indexes?

    Currently before the table is truncated, the index is dropped then after add all the record the index is created. Is it the right way to do?

    Thank you for your reply.

    NL

     

  • April 3, 2007 at 9:01 am

    #698319

    Index should not be changed. Dropping indexes before truncating a table is for breaking relations between tables.

  • April 3, 2007 at 12:02 pm

    #698364

    Just truncate the table.  SQL Server will automatically handle the indexes.

    Regards,

    Carlos

  • April 3, 2007 at 4:47 pm

    #698421

    Thank you.

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

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