Suggestions improved for longer scripts.Data types are now suggested if running in a disconnected query.Improved support for table-valued variables and parameters.Improvements to snippet suggestions after aliases.Query hint option IGNORE_NONCLUSTERED_COLUMNSTORE_INDEX is now suggested.Suggestions added for FEDERATION related keywords on Azure.

CLR methods are now suggested for hierarchyid, geometry and geography CLR types.

Columns in CREATE TABLE statement are suggested for PRIMARY and FOREIGN keys.

Triggers in ALTER TABLE suggestions are now filtered by the table.

Suggestions added for the following object types:.

To rename a variable or alias, place your cursor over an instance of the variable or alias you want to rename and press F2: You can now use SQL Prompt to rename all occurrences of a variable or alias in a query.

To use object definition case, in the SQL Prompt options, go to Format > Case and select Use object definition case. You can now use the object name's case for user-defined objects (tables, views, user-defined data types, etc) when applying casing options.įor example, if a data type named MyType is used in a script as mytype, when you format the script or apply casing options SQL Prompt will change the object's case to MyType. In Management Studio, go to Tools > Options > Environment > Fonts and Colors and select a new color for Brace Matching (Rectangle): If you want to change the highlight color, you can use the Management Studio functionality for customizing colors. When you're writing an INSERT statement, SQL Prompt now automatically highlights matching columns and data: When you place your cursor over a BEGIN or END keyword, SQL Prompt now automatically highlights the matching keyword: To insert semicolons, go to the SQL Prompt menu and click Insert Semicolons. Alternatively, hold Ctrl and press B then C. You can now use SQL Prompt to automatically insert missing semicolons after each statement in a query. This executes from the start of the script to the cursor, including the statement under the cursor. You can also execute to the cursor by pressing Ctrl + Shift + F5. You can also execute the current batch (ie code between two GO commands) by pressing Alt + Shift + F5. When you press Shift + F5, only the second statement is executed: In a query window, you can now execute the SQL statement under your cursor by pressing Shift + F5.įor example, if you have a query containing two statements and your cursor is placed on the second statement: Version 6.4.0 - September 16th, 2014 Execute current statement

Redgate sql prompt formatter batch