SQL Server transaction rollback

Question

Will the ROLLBACK command delete the temporary table created during the transaction?

thanks

Answer 1

Yes, it will also roll back all the work that was done in this temporary table before deleting it. This can be prevented by creating a temporary table before creating the transaction or by using a table variable that is not affected by the transaction.