Deleting Column Defaults

To remove column defaults, modify them to be NULL.

The following statement removes the default from the order_date column:
ALTER TABLE sales_order
MODIFY order_date DEFAULT NULL
Parent topic: Column Defaults Encourage Data Integrity