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
If your database project is not already open, open it in Solution Explorer.
In Solution Explorer, click the database project.
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
If your database project is not already open, open it in Solution Explorer.
Do either of the following:
In Solution Explorer, click the file that contains the database object.
In Schema View, click the database object.
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 and Server Projects