Hp Neoview Release 2.4 Software Manual de usuario descargar pdf (Pagina 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

1 2 ... 23 24 25 26 27 28 29 30 31 32 33 ... 69 70

Comentarios a estos manuales

Sin comentarios

Hp Neoview Release 2.4 Software Manual de usuario Pagina 28

Comentarios a estos manuales

Relacionado con productos y manuales para Software Hp Neoview Release 2.4 Software