Better intellisense for temp tables for DROP TABLE IF EXISTS
I frequently have code like this:
SELECT *
into #mytemptable
FROM mytable m
and then I remember I need to drop the temp table if it exists.. so I start typing
DROP TABLE IF EXISTS # when I get to this point, I wish the intellisense would recommend #mytemptable but it only recommends previous #temp tables. I wish for this type of statement, it would prompt for all #temp tables in the query window.
DROP TABLE IF EXISTS # <-- intellisense here is needed
SELECT *
into #mytemptable
FROM mytable m
see image... there is no intellisense
https://imgur.com/a/8xGvfbX
Gabe
shared this idea
AdminDevart
(_, Devart)
responded
dbForge parses the object only after it’s declared. So, if the table is declared in the INTO clause, it will be offered only below the place it’s declared in the script and not above.
-
AdminDevart
(_, Devart)
commented
Hi,
Thanks for your patience!
Please note that if you're using CREATE TABLE #TempTable in the same document,
your temp table will be included in the DROP TABLE IF EXISTS statement on the first line.
Best,
Devart Support Team