Dropping Temp Tables

• Justin D Loranger

  SSC Enthusiast

  Points: 128

  More actions

  July 11, 2007 at 9:19 am

  #175221

  If a temp table with an index is dropped, is the index dropped as well?

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  July 11, 2007 at 9:25 am

  #718675

  Yes

  

• Sugesh Kumar

  One Orange Chip

  Points: 27311

  More actions

  July 16, 2007 at 2:27 am

  #719587

  Yes when a table is dropped the depending objects like constraints, indexes are also dropped.

  Cheers,
  Sugeshkumar Rajendran
  SQL Server MVP
  http://sugeshkr.blogspot.com