HP Integrity NonStop J-Series - Manual (Page 66)

2. In the right pane, click Columns.
The following details related to view columns appear:
•
Column Name — The name of the column (string).
•
Source Object — The name of the source object associated with the column. If it is a
computed object, this field is blank. Clicking the source object name directs you to the
location of the object.
•
Data Type: — The SQL data type of the column.
•
Nullable: — If a column is NOT NULL or NOT NULLABLE NOT DROPPABLE , the value
displayed is Not Nullable Not Droppable . Otherwise, the field is blank.
•
Default: — The default value of the column.
•
Heading: — The string to be used as the column heading when a SELECT statement in
MXCI is used to display the column.
Viewing attributes of a view
To view the attributes of a view:
1.
In the navigation tree, select the view.
2. In the right pane, click Attributes.
The following details related to view attributes appear:
•
Name — The name of the view.
•
Metadata UID — Internal UID number of the view.
Viewing information on related objects
To view information on related objects:
1.
In the navigation tree, select the view.
2. In the right pane, click Related Objects.
The following details appear:
•
Relationship: — The attribute specifies the relationship of the view with the object specified.
The available values for this field are
Uses , Used By , and Has .
•
Related Object Type: — This attribute specifies the type of the related object. The available
values are
Table and View .
•
Related Object Name: — This attribute specifies the three-part ANSI object name. The
object name is linked to the related object.
•
Metadata UID: — The unique ID of the view.
•
Creation Time: — The time and date when the related object was created. The time and
date are expressed in the
yyyy-MM-dd HH:mm:ss.FFFFFF format.
•
Redefinition Time: — The time and date when the related object was last redefined. The
time and date are expressed in the
yyyy-MM-dd HH:mm:ss.FFFFFF format.
Viewing DDL information of a table
To view DDL output for a view:
1.
In the navigation tree, select the view.
2. In the right pane, click DDL.
In the right pane, the SQL statement used to create the view appears.
66 Viewing database objects