Automatically add DROP TABLE IF EXISTS for #temp tables
It would be nice if SQL Prompt had a way to add in the code DROP TABLE IF EXISTS #table for temp tables. Ideally it would add the statement immediately before the table is created from a CREATE TABLE or SELECT INTO statement.
11
votes
garrett
shared this idea
-
Chad commented
FYI, as a work around you can use snippets. I have a snippet that uses the $PASTE$ variable. After I create the table using SELECT INTO, I copy the name of the table and then type 'dite' for the snippet. I also have ones for views, procs and functions.