Quick Reference Guide - Redgate

1 Quick Reference Guide Formatting & refactoring shortcuts Navigation shortcuts Code-completion shortcuts Rename variables/aliases F2 Script object as ALTER F12 Show suggestions Ctrl+Space Format SQL Ctrl+K, Ctrl+Y. Execute current statment Shift+F5. Uppercase keywords Ctrl+B, Ctrl+U Refresh suggestions Ctrl+Shift+D. Expand wildcards Ctrl+B, Ctrl+W Select in Object Explorer Ctrl+F12. Code suggestions on/off Ctrl+Shift+P. Qualify object names Ctrl+B, Ctrl+Q Tab history Ctrl+Q. Add/remove square brackets Ctrl+B, Ctrl+B Switch to/from column picker Ctrl+Left / Ctrl+Right Summarize script Ctrl+B, Ctrl+S.

2 Insert semicolons Ctrl+B, Ctrl+C. Move up/down suggestions Ctrl+Up / Ctrl+Down Encapsulate as new stored procedure Ctrl+B, Ctrl+E Find unused variables and parameters Ctrl+B, Ctrl+F box lters Top snippets Snippet placeholders SELECT * FROM ssf Inserts the current date $DATE$. You can specify a custom date format, for example $DATE(MM/dd/yyyy)$. INNER JOIN ij Inserts the current time $TIME$. You can specify a custom time format, for example $TIME(HH:mm:ss)$. INSERT INTO ii ALTER PROCEDURE ap Inserts the name of the connected user $USER$. ORDER BY ob Inserts the contents of the clipboard $PASTE$.

3 LEFT OUTER JOIN loj Inserts the name of the machine running SQL Prompt $MACHINE$. BEGIN/END be SELECT TOP 100 * FROM st100 Speci es the cursor position when the snippet is inserted $CURSOR$. CREATE PROCEDURE cp Inserts the name of the connected SQL server $SERVER$. DELETE FROM df Inserts the name of the connected database $DBNAME$. GROUP BY gb $SELECTIONSTART$. CREATE TABLE ct Selects a block of the snippet text when the snippet is inserted $SELECTIONEND$. Code productivity tips Formatting & refactoring tips Tab history tips Navigation tips Suggestions can be matched by parts or rst SQL formatting can be con gured to your Search through all your open and recently Script objects as ALTER straight from query letters of names preferred style, in Options > Styles closed scripts windows (F12)

4 S Mid-string suggestions can also be helpful if Wildcards can be expanded directly from the Remove all tabs older than a speci c tab, or Use the object de nition box on columns to you remember part of an object name query window close them individually see column dependencies The column picker makes it easier to choose Formatting and refactoring commands can Rename a closed tab for easier retrieval Find all the invalid objects in your database, columns for your queries also be applied to selections via the menu Type less using code snippets. Add your Smart rename lets you rename objects and Open to restore tabs from your previous own and share them using your favorite le update all references to them session automatically sharing service ( Dropbox).