Feature request - temp tables

wonderbisonwonderbison Posts: 18 Bronze 1
in SQL Prompt

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

Tagged:
· Share on Twitter

Answers

Sign In or Register to comment.