Hp Neoview Release 2.5 Software Bedienungsanleitung Seite 69

  • Herunterladen
  • Zu meinen Handbüchern hinzufügen
  • Drucken
  • Seite
    / 284
  • Inhaltsverzeichnis
  • LESEZEICHEN
  • Bewertet. / 5. Basierend auf Kundenbewertungen
Seitenansicht 68
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
Seitenansicht 68
1 2 ... 64 65 66 67 68 69 70 71 72 73 74 ... 283 284

Kommentare zu diesen Handbüchern

Keine Kommentare