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.
In This Section
See Also
- For column-level changes, see Managing Table Columns.
- For details about changing and reorganizing table partitions, see Partitioning Existing Table Data.