Try OpenEdge Now
skip to main content
Online Help
Introducing Progress DB Navigator : Reference : MS SQL Server database : MS SQL Server DB Structure View
MS SQL Server DB Structure View
When you open a connection in the Connections view, the schema for the database appears in the DB Structure view. The DB Structure view is a tree view that shows a separate structure for each schema under the root node Database.
Note: You can configure DB Navigator to display or hide schemas. By default, catalogs are displayed while schemas are hidden from view. See DB Navigator preferences for more information.
When you select certain nodes in the DB Structure view, properties and values appear in the DB Details view.
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.
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:
Displays virtual systems tables and other metaschema tables. These tables cannot be altered.
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.
Displays the names of all created views.
Displays all procedures that are stored in the database and available for reuse.
Displays all triggers, which execute in response to a predefined event or activity.
Displays all functions, or pieces of a program that you can use separately from the remainder of the program.
Displays the session information for the current catalog.
Below the database node is a Monitor node that contains the following subnode:
Displays the information for the current database session.