Use the Table page of the Alter Table notebook to alter the table
properties.
You can change the comment, select a lock size, determine the percentage of
free space on each page, select data capture for propagation, extend the data
capture to include long variable length columns, and indicate whether data is
to be appended to the end of the table data.
Fields and controls
Authorities and privileges
To alter table properties:
- Open the Alter Table notebook.
- Optional: In the Comment field,
type a new comment or edit the existing comment.
- Optional: Select a lock size in the Lock
size field to specify the use of row locks or table locks when
accessing the table. Use of this field does not prevent normal lock
escalation.
Attention: Your new lock size selection is saved in the
system but will not be displayed the next time you view this field.
- Optional: Select a value in the Percentage of
free space to be left during load or reorganization field to change
the percentage of each page to be left as free space during load or
reorganization.
- Optional: Select or clear the Data capture
for propagation check box to indicate whether extra information
regarding SQL changes to this table will be written to the log if this table
is replicated.
- Optional: Select or clear the Include long
variable length columns check box to indicate whether to extend the
data capture for propagation function to include long varchar and long
vargraphic columns in the log.
Attention: You must first select the Data capture for
propagation check box to enable the Include long variable length
columns check box.
- Optional: Select or clear the Append table
data to the end of the last table page check box to indicate whether
data is to be appended to the end of the table data.
- If you do not want to make any additional changes to the table, click on
OK to alter your table and close the Alter Table notebook.
Otherwise, continue on to one or more of the optional tasks.
Related information