4

Will the ROLLBACK command drop a temporary table which is created during the transaction ?

Thanks

Improve this question

1 Answer 1

Reset to default
4

Yes, it will also roll back all work that has been done on that temp table before it is dropped. You can prevent this by creating the temp table before the transaction is created, or use a table variable which is not affected by the transaction.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.