Table page
Table schema
Table name
Table space
Index table space
Long data table space
Comment
Lock size
Percentage of free space to be left during load or
reorganization
Data capture for propagation
Include long variable length columns
Append table data to the end of the last table
page
Duplicate table data on each database partition
Cardinality varies significantly at run time (from
empty to quite large)
OK
Show SQL
Cancel
Table schema
This box displays the name of the schema specified for the table that you're altering. You cannot alter the schema.
Table name
This field displays the name currently specified for the table that you're altering. To specify a different name, use the Rename Table function. You cannot alter the table name using the Alter Table function.
Table space
This box displays the the name of the table space in which the table was created. You cannot alter the table space.
Index table space
This box displays the name of the table space in which any indexes on the table were created. You cannot alter the index table space.
Long data table space
This box displays the name of the table space in which the values of any long columns are stored. Long data can be LONG VARCHAR, LONG VARGRAPHIC, LOB data types, or distinct types with any of these as source types. You cannot alter the long data table space.
Comment
Optional: This field contains the comment currently specified for the table. To change the comment, type the new comment in this field. You can type up to 254 characters, including embedded blanks.
Lock size
This box contains the size (granularity) of locks used when the table is accessed. To change the lock size, click on the down arrow to display the list and select one.
The lock size can be one of:
Table locks may improve the performance of some queries by limiting the number of locks to be acquired, however, concurrency is also reduced because all locks are held over the complete table.
Use of the Lock size control will not prevent normal lock escalation from occurring.
Percentage of free space to be left during load or
reorganization
Use this field to specify the percentage of each page to leave as free space during load or reorganization.
The first row on each page is added without restriction. When additional rows are added, the value specified in this field determines the percentage of free space left on each page.
Select a percent from 0 to 99.
Data capture for propagation
This check box indicates whether extra information regarding SQL changes to this table be written to the log. This extra information is required if this table will be replicated. This check box must be selected if you plan to use this table as a source for replication.
Include long variable length columns
This check box indicates whether long varchar and long vargraphic column information for the table will be written to the log during data capture for propagation.
Select the check box to enable a long field log record that includes long varchar and long vargraphic columns in the log. If you select this check box for tables that do not have long variable length columns at this time, you can alter a table in the future to include long variable length columns.
Append table data to the end of the last table page
This check box indicates whether data is appended to the end of the table data or placed where free space is available in data pages.
If you clear the check box the table should be reorganized as information about available free space is not accurate and may result in poor performance during insert.
Duplicate table data on each database partition
This check box indicates whether all of the data for the table is being duplicated on each database partition of the nodegroup of the table. This option is selected at the time the table is created.
Duplicating table data on each database partition may improve performance in situations where collocation is not possible.
Cardinality varies significantly at run time (from empty to quite
large)
Check this check box to indicate to the optimizer that the cardinality of your table can vary significantly at run time, from empty to quite large. To access your table, the optimizer will use an index scan rather than a table scan, regardless of the statistics, if that index is index-only (all columns referenced are in the index) or that index is able to apply a predicate in the index scan.
If this box is not checked, access plans to this table will be based on the existing satistics and on the optimization level in place.
Columns page
Columns
Add
Change
Remove
Select
Up
Down
OK
Show SQL
Cancel
Columns
This box contains a list of all of the columns defined for the table that you're altering. Use this box to view your column definitions or to select a column that you want to change, remove, or reorder. You can select an existing column to change the comment. You can select a new column to change any field, remove the new column from the table, or reorder the new column among the other new columns. Click on Add to add a column to this list.
Add
Click on this push button to open the Add Column window so you can add a new column to the table that you're altering.
You can add up to 500 columns to your table. The sum of the byte counts of the columns must not be greater than 4005.
Change
Click on this push button to open the Change Column window so that you can change an attribute of the column that is selected in the Columns box. You can change the comment for an existing column or any field for a column that you're adding.
Remove
Click on this push button to remove from your table the column that is selected in the Columns box. You can remove only columns that you're adding.
Select
Click on this push button to open the Select Columns window so that you can select a predefined column to add to the table that you're altering.
Up
Click on this push button to move the column that is selected in the Columns box up one position. You can reorder only new columns among other new columns.
Down
Click on this push button to move the column that is selected in the Columns box down one position. You can reorder only new columns among other new columns.
Primary Key page
Available columns
>, >>, <, <<
Primary key columns
Constraint name
OK
Show SQL
Cancel
Available columns
This box lists all of the columns defined for the table that are not currently defined as primary key columns. Use this box to select the column or columns that you want to define as primary key columns and then click on the > push button. You can select one or more columns at the same time.
You can define up to 16 columns to be primary key columns. The sum of their length attributes must not exceed 255 bytes.
Attention: You cannot define columns of data type LOB, LONG VARCHAR, or LONG VARGRAPHIC to be primary key columns.
>, >>, <, <<
Use these push buttons to change the list of columns displayed in the Available columns and Primary key columns boxes. You can use:
Primary key columns
This box lists all of the columns defined as primary key columns. The order of the columns in this list is significant because the database manager uses the primary key for efficient access to table data.
Use this box to view the list of primary key columns or to select a column or columns to remove from the list with the < push button.
To add a column to this list, select a column from the Available columns box and then click on the > push button.
Constraint name
Use this field to specify the constraint name for the primary key. If the primary key is already defined, this field contains the constraint name currently specified for the primary key that you're altering. To specify a new or different name, type a name for the constraint in this field. This name:
If you do not specify a constraint name for a primary key that you're defining, one is generated for you.
Partitioning Key page
Available columns
>, >>, <, <<
Partitioning key columns
OK
Show SQL
Cancel
Available columns
This box lists all of the columns defined for the table that are not currently defined as partitioning key columns. Use this box to select the columns that you want to define as partitioning key columns and then click on the > push button.
Attention: You cannot define columns of data type LOB, LONG VARCHAR, or LONG VARGRAPHIC to be partitioning key columns.
>, >>, <, <<
Use these push buttons to change the list of columns displayed in the Available columns and Partitioning key columns boxes. You can use:
Partitioning key columns
This box lists all of the columns defined as partitioning key columns. The order of the columns in this list is significant because the database manager uses the partitioning key for efficient access to table data.
Use this box to view the list of partitioning key columns or to select columns that you want to remove from the list with the < push button.
To add a column to this list, select a column from the Available columns box and then click on the > push button.
Foreign Keys page
Foreign keys
Add
Change
Remove
OK
Show SQL
Cancel
Foreign keys
This box lists all of the foreign keys defined for the table that you're altering. Use this box to view your foreign key definitions or to select a foreign key that you want to change or remove. Click on Add to add a foreign key to this list.
Add
Click on this push button to open the Add Foreign Key window so you can add a new foreign key to the table that you're altering.
Change
Click on this push button to open the Change Foreign Key window so you can change an attribute of the foreign key that is selected in the Foreign keys box.
Remove
Click on this push button to remove the foreign key that is selected in the Foreign keys box from your table.
Check Constraints page
Check constraints
Add
Change
Remove
OK
Show SQL
Cancel
Check constraints
This box lists all of the check constraints defined for the table that you're altering. Use this box to view your check constraint definitions or to select a check constraint that you want to change or remove. Click on Add to add a check constraint to this list.
Add
Click on this push button to open the Add Check Constraint window so you can add a new check constraint to the table that you're altering.
Change
Click on this push button to open the Change Check Constraint window so you can change an attribute of the check constraint that is selected in the Check constraints box.
Remove
Click on this push button to remove from your table the check constraint that is selected in the Check constraints box.