Deleting Column Defaults

To remove column defaults, modify them to NULL.

This 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