Databases consist tables, views and stored procedures, each of which represents a list of columns:
New nodes that appear under a connection when it is live represent tables, views, and procedures.
The following table lists Explorer icons and their descriptions.
| Icon | Description |
|---|---|
| Table | |
| Column | |
| Column (Primary key) | |
| Column (Unique key) | |
| Index | |
| Foreign key | |
| Column in foreign key | |
| View |
Click on an index node to see a list of the columns indexed for a given table.
Click the Views node to see the Views on a given database.
View columns are dimmed to indicate that you cannot change the physical characteristics
of the columns in a view. However, you can change a view by dropping the view
and subsequently recreating it.
| See also | |
|---|---|
| Enabling and Disabling Debug Mode to Monitor SQL Commands | |