Connecting to Data with Server Explorer/Database Explorer

Server Explorer/Database Explorer is the server management console for Visual Studio. Use this window to open data connections and to log on to servers and explore their system services.

Use Server Explorer/Database Explorer to view and retrieve information from all of the databases you are connected to. You can do the following:

  • List database tables, views, stored procedures, and functions

  • Expand individual tables to list their columns and triggers

  • Right-click a table to perform actions, such as showing the table's data or viewing the table's definition, from its shortcut menu.


In the Visual Studio Express products, this window is named Database Explorer. In all other Visual Studio products, this window is named Server Explorer.

To access Server Explorer/Database Explorer, choose Server Explorer or Database Explorer on the View menu. To make the Server Explorer/Database Explorer window close automatically when not in use, choose Auto Hide on the Window menu.

  • Connections to various types of databases are listed under the Data Connections node. You can explore databases of other types than SQL server, and running on platforms other than Windows. For example, you can create a data connection to an Oracle database running on a UNIX or a Microsoft Windows system.

The following topics provide guidance on using Server Explorer/Database Explorer to create and manage data links and database connections.

In This Section