Home |
Previous Page | Next Page Object-Relational Databases > Understanding Type and Table Inheritance in Dynamic Server > Table Inheritance >
You cannot use the ALTER TABLE statement
to add, drop, or modify the columns of a table in a table hierarchy.
You can use the ALTER TABLE statement to
add, drop, or modify constraints.
The process of adding, dropping, or modifying a column of a table
in a table hierarchy (or otherwise altering the structure of a table)
can be a time-intensive task.
To alter the structure of a table in a table hierarchy
- Download data from all subtables and the supertable that you
want to modify.
- Drop the subtables and subtypes.
- Modify the unloaded data file.
- Modify the supertable.
- Re-create the subtypes and subtables.
- Upload the data.
Home |
[ Top of Page | Previous Page | Next Page | Contents |
Index ]