Changing Column Defaults

To change column defaults, use the same form of the ALTER TABLE statement you use to create defaults.

The following statement changes the default value of a column named order_date from its current setting to CURRENT DATE:
ALTER TABLE sales_order
MODIFY order_date DEFAULT CURRENT DATE
Parent topic: Column Defaults Encourage Data Integrity