These pages cover SQL Prompt 8, which is not the latest version. Help for other versions is also available.
Renaming scripted objects
Published 08 January 2015
Renaming variables and aliases
You can use SQL Prompt to rename all occurrences of a variable or alias in a query.
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 also use F2 to rename:
- SQLCMD variables
- temporary tables
- columns in temporary tables
- transactions