Change or drop a column default value

You can use the ALTER TABLE command to change or drop the default value of a column, which affects future inserts into the table.

To change the default value of a column, enter:

   MYDB.SCHEMA(USER)=> ALTER TABLE weather ALTER col1 SET DEFAULT 100;

To drop the default value of a column, enter:

   MYDB.SCHEMA(USER)=> ALTER TABLE weather ALTER col1 DROP DEFAULT;