Browsing Structures

Databases consist of the following, each of which represent a list of columns:

The Database Explorer follows this structure when displaying the database.
Accordingly, new nodes that appear under a connection when it is live
represent tables, views, and procedures.

To browse a table

  1. Click on the table node..
  2. Expand the table node to see the table's columns and an indexes node, showing all indexes defined on a given table.

Columns

Columns are distinguished by color:

Indexes

Click on an index node to see a list of the columns indexed for a given table.

Views

Click the Views node to see the Views on a given database.

View columns are shaded gray; you cannot change the physical characteristics
of columns in a view. However, you can change a view by dropping the view and subsequently
recreating it.

Procedures

Choose Procedures to view stored procedure names and their in and out parameters.

See also
Enabling and Disabling Debug Mode to Monitor SQL Commands

Legal Notices