Altering Table Definitions

You can modify a table's definition with ALTER TABLE , in response to evolving database schema requirements. Changing a table definition is often more efficient than staging data in a temporary table, consuming fewer resources and less storage.

See Also

• For column-level changes, see Managing Table Columns.
• For details about changing and reorganizing table partitions, see Partitioning Existing Table Data.