Browsing a Database in the Data Explorer
Go Up to How To Perform Database Procedures
After you have a live connection, you can use the Data Explorer to browse database objects.
To browse database objects
- Choose View > Data Explorer.
- Expand a provider node to expose the list of available connections.
- Expand a connection node to view the list of database objects.
Note: If you receive an error because your connection is not live, you should refresh your provider, and/or modify your connection.
To retrieve data from the database
- Expand a connection in the Data Explorer.
- Double-click a table name or view name to retrieve data. This operation returns a result set into a tabbed Data Explorer page in the Code Editor.
Tip: You can also select a table in the Data Explorer and right-click to display a pop-up menu with a Retrieve Data From Table command.
To run a stored procedure
- Choose View > Data Explorer.
- Expand a connection in the Data Explorer and locate a stored procedure.
- Double-click the stored procedure to view its parameters. The parameters open in a separate page on the design surface.
- Edit input parameters as necessary.
- Click the Execute button in the top left corner of the page to execute the procedure. The result set appears in a datagrid.
Tip: You can also select a procedure in the Data Explorer and right-click to display a pop-up menu with an Execute command.