Shortcut: Using Snippets in SSMS to Improve the Drop Database Statement
In an earlier post, I showed how to create a DROP DATABASE template in SQL Server Management Studio (SSMS). At the time, I mentioned that a template wasn’t the best option because a command like this is normally inserted into a script; it’s not the whole script.
That’s where snippets shine. Let’s create a snippet for it.
First let’s open Code Snippets Manager (Tools > Code Snippets Manager):
You’ll see the existing snippet folders. I’ve clicked Add, then created a new folder called GL_Snippets.
2018-01-11