This documentation is archived and is not being maintained.

How to: Set a Default Database Reference for a Database Project

You can designate a default database reference for your database project. A default reference is useful for designing queries and running scripts. After setting a default database reference, you can still run scripts on other databases 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.


The dialog boxes and menu commands you see might differ from those described in Help depending on your active settings or edition. To change your settings, choose Import and Export Settings on the Tools menu. For more information, see Visual Studio Settings.

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.