Displaying table attributes

To display the table attributes:

Procedure

  1. Select a table in the left pane.
  2. In the right pane, click Attributes.

    The following details appear:

    • Name—The name of the table.

    • Metadata UID—The internal UID number of the table.

    • Last Updated Statistics—A string value of Never or a timestamp in the yyyy-MM-dd HH:mm:ss.FFFFFF format.

    • Audit Compressed—The property indicates whether the compressed audit-checkpoint messages are generated for Disk Process 2 (DP2) files. It is expressed as True or False.

    • Clear On Purge—If the value is True, then the contents of the table are overwritten when it is purged. Otherwise, the contents are not overwritten.

    • Block Size—The length of a block.

    • Maximum Size—The maximum size, expressed in megabytes, to which a table can grow. If the maximum size is 0, then the string Determined by system appears.

    • Record Size—The row size, expressed in bytes, in each logical record.

    • Creation Time—The time and date when a table 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 a table was last redefined. The time and date are expressed in the yyyy-MM-dd HH:mm:ss.FFFFFF format.

    • Owner— The owner of the table.