Table Properties Dialog
You can view table properties using the Table Properties dialog. This dialog contains the following pages:
• General
• Columns
• Locations
For more information, see
View Table Properties.
General Page
The General page displays settings in the following areas:
• General
• Page Information
• Advanced
General Options
Name
The name of the table
Owner
The owner of the table
Alter Date
The last time this table was altered. This date is updated whenever the logical structure of the table changes, either through changes to the columns in the table or changes to the primary key. Physical changes to the table, such as changes to data, secondary indexes, or physical keys, do not change this date. Blank if unknown. This is a date field.
Comment
Lets you specify a comment about the table
Create Date
The object’s creation date. Blank if unknown. This is a date field.
Duplicate Rows
Indicates whether the table allows duplicate rows. Blank if unknown. The table storage structure (unique as opposed to non-unique keys) can override this setting.
Journaling
Indicates if journaling is enabled for the table, or if journaling will be enabled at the next checkpoint. This is blank if journaling does not apply.
Location
The first location of the table. If there are additional locations for a table, they are shown in the iimulti_locations table and multi_locations will be set to Y.
Number of Rows (Estimated)
The estimated number of rows in the table. Set to -1 if unknown.
Storage Structure
The storage structure for the table: HEAP, HASH, B-TREE, or ISAM. Blank if the table structure is unknown.
Type
The type of table
Version
Version of the object; enables the tools to determine where additional information about this particular object is stored. This reflects the database type, as well as the version of an object within a given database. For tables, the value for this field is IIversion.
Page Information Options
Number of Pages
The estimated number of physical pages in the table. Set to -1 if unknown.
Overflow Data Pages
The estimated number of overflow pages in the table. Set to -1 if unknown.
Page Size
The page size for the table
Advanced Options
Base Table for View
Checked if the table is a base for a view definition, cleared if not
Compression
Checked if the table is stored in compressed format, cleared if the table is uncompressed
Integrities
Y if this object has Ingres-style integrities. If the value is blank, you must query the iiintegrities table to determine if integrities exist.
Optimizer Statistics
Checked if this table has entries in the iistats table, cleared if not
Permissions
Y if this object has Ingres-style permissions, N if not
Row Width
The size, in bytes, of the uncompressed binary value for a row of this query object
Columns Page
The Columns page lists the following column information:
• Column Name
• Type
• Length
• Nulls
• Defaults
• Key sequence
Locations Page
The Locations page lists the following location information:
• Location name
• Sequence number