Nonstop Database, HiRDB Version 9 System Operation Guide
- Executor: Table owner
You modify a table's definition by executing ALTER TABLE with the CHANGE operand specified. The following definitions can be modified:
- Data size of a variable-length character string
- Change from CHAR to MCHAR
- Maximum number of elements in repetition columns
- Changing the non-NULL value constraint without a default value to one with a default value
- Changing a cluster key without the uniqueness constraint to one with the uniqueness constraint
- Changing a cluster key with the uniqueness constraint to one without the uniqueness constraint
- Minimum unit of locked resources for the table
- Hash function
- Notes
- The definition of a LOB column cannot be modified.
- The definition of an abstract data type column cannot be modified.
- Changing the definition of a table invalidates any stored routines that use that table. If this happens, use the ALTER PROCEDURE or ALTER ROUTINE statement to re-create each stored routine.
- Changing the definition of a table specified in a trigger SQL statement invalidates the trigger. In addition, deleting a column that is accessed by the trigger action condition or from within an SQL statement using an old and new values correlation name invalidates the trigger. If the trigger becomes invalid, use the ALTER TRIGGER or ALTER ROUTINE statement to re-create the trigger.
- After a table's definition has been changed, execute the optimizing information collection utility (pdgetcst command) if necessary. For details about whether execution of the optimizing information collection utility is required, see the manual HiRDB Version 9 Command Reference.
- Organization of this section
- 13.8.1 Example: Changing the data size of a column
All Rights Reserved. Copyright (C) 2011, 2015, Hitachi, Ltd.