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
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 |