Try OpenEdge Now
skip to main content
Online Help
Introducing Progress DB Navigator : Reference : MS SQL Server database : MS SQL Server DB Details view
 
MS SQL Server DB Details view
The DB Details view is a read-only display of information specific to the selected node in the DB Structure view. You can access this detailed view through the context menu for the selected node.
Note: This detailed view is available only for certain nodes. If the detailed view is unavailable for a node you select in the DB Structure view, no information appears in the DB Details view.
The content of the DB Details view changes depending on which node you select in the DB Structure view. When you select a child of one of the nodes listed in the left column of the following table, the corresponding information appears in the DB Details view:
SYSTEM TABLE or TABLE or VIEW
For a child node, displays details about the following:
*Columns -A list of all columns and related SQL information. You can sort the column names in ascending or descending order by clicking the Column label.
*Indexes -A list of indexes in the selected table.
*Primary key - A list of the primary keys defined for the selected table.
*Foreign key - A list of any foreign key restraints defined for a selected SQL table.
*Preview - A subset of the records in the selected table. You can set the number of rows returned in the Preferences page.
*Row count - The total number of rows in the selected table.
*Privileges - A list of both table and column privileges (as a toggle).
PROCEDURE or TRIGGER
For a child node, displays the SQL code in the Source tab and property/value details, such as date created, in the Info tab.
FUNCTIONS
Displays the SQL code in the Source tab and property/value details, such as date created, in the Info tab.
SESSIONS
Displays details about the current schema.