How can we help you today? How can we help you today?

Feature request - temp tables

Hi

I was wondering if it was possible for SQL Prompt to be able to search code for temp tables and via an option/keystrokes add at the start, or the end, do a check for temp tables existing and if they do, then drop.

I am finding in a new role I am looking at code with temp table creation via a SELECT INTO or CREATE TABLE but no DROP TABLE so the code is not re-runnable when I extract it and when I don't want to run in a transaction.

Thanks

wonderbison
0

Comments

1 comment

Sort by

Add comment

Please sign in to leave a comment.