Do I need to drop index on temp table?

Posted by Phil on Stack Overflow See other posts from Stack Overflow or by Phil
Published on 2010-05-24T08:42:54Z Indexed on 2010/05/24 9:21 UTC
Read the original article Hit count: 168

Filed under:

Hi,

Fairly simple question, but I don't see it anywhere else on SO:

Do indexes (indices?) on a temporary table get automatically deleted with the temporary table?

I'd imagine they do but I don't really know how to check to make sure.

Thanks,

Phil

© Stack Overflow or respective owner

Related posts about sql-server-2005