Share via


How to: View Database Objects

Solution Explorer lists the files that make up your database project. The files also contain the definitions for the objects in your database. You can use Schema View to display an object-based representation of your database project instead of the file-based representation in Solution Explorer.

To display your database project in Schema View

  1. If your database project is not already open, open it in Solution Explorer.

  2. In Solution Explorer, click the database project.

  3. On the View menu, click Schema View.

    Schema View displays a top-level node for each database project in your solution.

To display the definition of a database object

  1. If your database project is not already open, open it in Solution Explorer.

  2. Do either of the following:

    1. In Solution Explorer, click the file that contains the database object.

    2. In Schema View, click the database object.

  3. On the View menu, click Open.

    The Transact-SQL (T-SQL) editor displays the definition of that database object.

See Also

Concepts

An Overview of Database Projects
Terminology Overview of Team Edition for Database Professionals

Other Resources

Working with Database Objects