MS SQL Server DB Structure View
- Last Updated: February 11, 2026
- 1 minute read
- OpenEdge
- Version 13.0
- Documentation
The top-level nodes in the MS SQL Server DB Structure view are Database and Monitor. You can use DB Structure view 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 MS SQL Server 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. |