How to: Fully Qualify the Names of Database Objects
You can reduce ambiguity in the definitions of your database objects if you update each object reference to include the name of the object's schema and, if the object has a parent, the name of the parent. By using database refactoring, you can identify and update these references automatically. For more information, see Fully Qualify the Names of Database Objects.
To fully qualify all names that are contained in the definition of a database object
In Schema View, right-click the object that contains names that you want to update, point to Refactor, and click Fully-qualify Names.
The Preview Changes dialog box appears and shows all names that will be updated.
Note
You cannot refactor database objects from the Transact-SQL editor.
(Optional) Review the changes, and decide which changes you want to apply. For more information, see How to: Preview Refactoring Changes.
To fully qualify all names that are contained in a .sql file in your solution
In Solution Explorer, right-click the script file (.sql) that contains names that you want to update, point to Refactor, and click Fully-qualify Names.
The Preview Changes dialog box appears and shows all names that will be updated.
Note
You cannot refactor database objects from the Transact-SQL editor.
(Optional) Review the changes, and decide which changes you want to apply. For more information, see How to: Preview Refactoring Changes.
To fully qualify all names that are contained in a schema
In Schema View, right-click the schema whose objects you want to update, point to Refactor, and click Fully-qualify Names.
The Preview Changes dialog box appears and shows all names that will be updated.
Note
You cannot refactor database objects from the Transact-SQL editor.
(Optional) Review the changes, and decide which changes you want to apply. For more information, see How to: Preview Refactoring Changes.
To fully qualify all names that are contained in the database project
In Solution Explorer, right-click the database project, point to Refactor, and click Fully-qualify Names.
The Preview Changes dialog box appears and shows all names that will be updated.
(Optional) Review the changes, and decide which changes you want to apply. For more information, see How to: Preview Refactoring Changes.
See Also
Tasks
How to: Deploy Database Refactoring Changes
Concepts
Move a Database Object to a Different Schema
Fully Qualify the Names of Database Objects
Expand Wildcard Characters in SELECT Statements