DB Output view

 

In the DB Output view, you can see the messages, parameters, and results that are related to the database objects that you work with.

In the Data perspective, the DB Output view displays information about actions that are related to stored procedures and user-defined functions (UDFs). For example, when you run a stored procedure on the database server, the DB Output view displays messages, parameters, and the results of any SQL statements that are run by the stored procedure. In addition to output from explicit stored procedures and UDFs, the DB Output view displays results when you sample the contents of a selected table.

The DB Output view includes an actions list on the left side of the view and several tabbed pages on the right side. The pages on the right side display information that is related to the action that is selected in the actions list:

• A Messages page displays messages, including the progress of actions

• A Parameters page displays the parameters for a routine or object

• A Results page displays the results of SQL statements that are run by a routine

The left side of the DB Output view contains the following fields:

Status

Shows the current state of the statement.

Action

Shows what kind of action occurred.

Object Name

Shows the name of the statement.

 

Parent topic

Overview of the Data perspective