The top-level nodes in the MS SQL Server DB Structure view are Database and Monitor. You can use filters to show only certain schema items in the view.
Database
The root node Database is at the top level of the DB Structure view. If the database supports catalogs and you have selected Show catalog in the DB Navigator preferences, all catalogs appear below the database node. If you have selected Show schema in the DB Navigator preferences, all schemas appear below the database node.
Beneath the schema and catalog nodes, the following child nodes appear:
| SYSTEM TABLE | Displays virtual systems tables and other metaschema tables. These tables cannot be altered. |
| TABLE | Displays all application tables. Table nodes expand to show
columns, indexes, and triggers.When you select a table name, data
and meta-data appear in the DB Details view. Note: Since
tables are displayed in ASCII order and sorting is
case-sensitive, all lowercase table names sort after the
uppercase table names.
|
| VIEW | Displays the names of all created views. |
| PROCEDURE | Displays all procedures that are stored in the database and available for reuse. |
| TRIGGER | Displays all triggers, which execute in response to a predefined event or activity. |
| FUNCTIONS | Displays all functions, or pieces of a program that you can use separately from the remainder of the program. |
| SESSIONS | Displays the session information for the current catalog. |
Monitor
Below the database node is a Monitor node that contains the following subnode:
| SESSIONS | Displays the information for the current database session. |