Export (0) Print
Expand All

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.

    NoteNote

    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.

    NoteNote

    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.

    NoteNote

    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.

Community Additions

ADD
Show:
© 2014 Microsoft