TSQL Constraints on Temp Tables

Question

Very quick and simple question. I am running a script to import data and have declared a temp table and applied check constraints to that table. Obviously if the script is run more than once I check whether the temp table already exists and if so, I drop and recreate the temp table. would that also drop and recreate the check constraints I placed on the temp table?

Logic says yes but I have been known to be wrong about such things.

Answer 1

Yes - dropping the temp table will drop any internal dependencies as well, including your constraints.

Answer 2

Yes, dropping the table will drop constraints, indexes etc that you may have created on it.

Also, if this is something you're doing repeatedly you may want to truncate it instead of drop/recreate it - that is typically a lot faster. (And sometimes, creating a "permanent" temp table can be a good idea for frequently occuring ops)