SQL Prompt 5

SQL Prompt enables you to modify a SQL script so that all object names are qualified in the format:

owner.object

Column names are qualified in the format:

table.column

Note

SQL Server name and database name qualifiers are not added to the names.
Qualifying object names is available only in SQL Prompt Pro Edition.

To qualify object names:

Open the script you want to modify in a SQL Server Management Studio query window.
If required, select a portion of SQL in the script that contains the object names that you want to qualify.
If you do not select any SQL, all object names in the script are qualified.
On the SQL Prompt menu, click Qualify Object Names.

You can undo the changes to the script using the standard SQL Server Management Studio Undo features.

To keep the changes, save the script.

Keyboard shortcut: hold Ctrl and press B then Q to qualify all object names in a script, or highlight a particular object to qualify only that one. (SQL Prompt 5.3 only)

SQL Prompt 5

Qualifying object names