Foreign keys tab, Attributes tab, Partitions tab – HP Neoview Release 2.5 Software User Manual
Page 69: Usage tab
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 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 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 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.
Usage Tab
To display usage information defined on the table:
Display Tables and Their Properties
69