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.

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.

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.