SQL Prompt 8

Help for older versions available.

These pages cover SQL Prompt 8, which is not the latest version. Help for other versions is also available.

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

Didn't find what you were looking for?