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
Comments
2 comments
-
sorry, this should probably be in the Product Forum. I don't see a way to move it
-
Hi Burke,
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-shortcutsHighlight 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.
I hope this information helps.
Best,
Dustin
Add comment
Please sign in to leave a comment.