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

  1. 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.

  2. (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

  1. 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.

  2. (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

  1. 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.

  2. (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

  1. 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.

  2. (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

Rename References to a Server or Database

Rename All References to a Database Object