ALTER TABLE: SET DEFAULT

— Assuming you have a table named ‘your_table’ and a column named ‘your_column’
— You want to add a default value of ‘your_default_value’ to ‘your_column’

— ALTER TABLE
ALTER TABLE PTBL_TRANSACTION
MODIFY QUANTITY DEFAULT 1;

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top