What are the challenges you face when working across database platforms? Take the survey
Options

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

Tagged:

Answers

Sign In or Register to comment.