Share via

Setting a Default Database Reference for a Database Project

  • Article

You can designate a default database for your database project. A default reference is useful for designing queries and running scripts. After setting a default database reference, you can still use other databases to design queries (using Design On) and run scripts (using Run On). You can also select which database to use by dragging a query or script file to the database reference in Solution Explorer.

To set a default database reference

  • In Solution Explorer, expand the Database References folder, right-click the database reference, and choose Set as Project Default from the shortcut menu.

See Also

Adding a Database Reference to a Database Project | Deleting a Database Reference from a Database Project | Database Connections and Database References | Managing Data with Database Projects