SQL Prompt 7

Renaming scripted objects

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
  • transcations

Didn't find what you were looking for?