Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

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

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.