Change the default value of a column of the table

SQL Server:

Alter Table Dbo.test Add Constraint

DF_TEST_COLUMN2 DEFAULT 'A' for Column2

Oracle:

ALTER TABLE "BV1TO1". "DT_CONTEST_SUPP" Modify ("Accept" default 1)