// First, store table names in a variable LET vTableList = ''; FOR i = 0 to NoOfTables() - 1 LET vTable = TableName($(i)); IF '$(vTable)' <> '$(t)' THEN TRACE 'Adding Table: $(vTable)'; LET vTableList = If(len(vTableList)>0, '$(vTableList)|', '') & '$(vTable)'; ENDIF; NEXT i; // Drop tables outside the initial loop LET vTableCount = SubStringCount('$(vTableList)', '|') + 1; FOR i = 1 to $(vTableCount) LET vDropTable = SubField('$(vTableList)', '|', $(i)); TRACE 'Dropping Table: $(vDropTable)'; DROP TABLE [$(vDropTable)]; NEXT
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter