HP Neoview Release 2.4 Software - Manual (Page 28)

Constraint Name: Name of the unique constraint. •
•
Columns: The name of the columns that are constrained.
Foreign Keys Tab
To display the foreign keys information on the table:
1. Select a Schema in the navigation tree and click the table name in the right pane, or open
the Tables folder and select a table name in the tree.
2. Click on the Foreign Key tab in the right pane.
In the right pane, these attributes are displayed:
•
Name: Name of the foreign key constraint.
• Foreign Table: Name of the foreign table.
• Local Column: Name of the local column of the foreign key.
• Foreign Column: Name of the foreign column of the foreign key.
• Enforced: Indicates if referential integrity is enforced.
Attributes Tab
To display the table attributes with the attribute name and value:
1. Select a Schema in the navigation tree and click the table name in the right pane, or open
the Tables folder and select a table name in the tree.
2. Click on the Attributes tab in the right pane.
In the right pane, these attributes are displayed:
•
Name: Name of the table.
• Log Inserts Only: A string value of “True” or “False.”
• Reorganize Enabled: A string value of “True” or “False.”
• Update Statistics Enabled: A string value of “True” or “False.”
• Last Updated Statistics: The string value of “Never” or a timestamp of the format
(yyyy-MM-dd HH:mm:ss.FFFFFF local time).
• Maximum Size: Maximum size in megabytes to which a table can grow. If maximum
size is 0, then the string “Determined by system” is displayed.
• Record Size: Row size in bytes in each logical record.
• Creation Time: Time and date when the table was created. Timestamp is in the format
(yyyy-MM-dd HH:mm:ss.FFFFFF local time).
• Redefinition Time: Time and date when the table was last redefined. Timestamp is in
the format (yyyy-MM-dd HH:mm:ss.FFFFFF local time).
Partitions Tab
To display the table partition information:
1. Select a Schema in the navigation tree and click the table name in the right pane, or open
the Tables folder and select a table name in the tree.
2. Click on the Partitions tab in the right pane.
In the right pane, these attributes are displayed:
•
Partition Number: The index number of the partition.
• Percent Allocated: The percentage full of the partition.
• Row Count: The current total number of rows in the partition.
• Max Size: The maximum size in bytes of the partition.
• Current EOF: The current data size of the partition in bytes.
28 Managing Database Objects