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

This documentation contains proprietary information and is protected by copyright law.
Copyright © 2026 Red Gate Software Limited. All rights reserved


Didn't find what you were looking for?