Feature request - temp tables

wonderbison

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

Alex B

Hi @wonderbison,

This is not current functionality within SQL Prompt.  You should suggest it on the SQL Prompt Uservoice forum!

Kind regards,
Alex