Altering table definitions
You can modify a table's definition with ALTER TABLE , in response to evolving database schema requirements.
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.