for long lists of items in an IN statement, I often like to Unformat them. is there a way to put a button in the Redgate toolbar to run "Unformat"? thanks
Highlight the code, hit Ctrl, and select Unformat. This will remove any carriage returns, tabs, extra spaces, and so on, and compact the script as much as possible.
You may need to type unformat in the search box to have it appear.
Answers
No worries, while there currently may not be a button in the toolbar for unformat there is a shortcut that may do the trick.
https://www.red-gate.com/blog/database-development/sql-prompt-shortcuts
You may need to type unformat in the search box to have it appear.
I hope this information helps.
Best,
Dustin