1--Altering an existing column to add a default constraint:
2ALTER TABLE {TABLE NAME}
3ADD CONSTRAINT {CONSTRAINT NAME}
4DEFAULT {DEFAULT VALUE} FOR {EXISTING COLUMN NAME}
5
6--Adding a new column, with default value, to an existing table:
7ALTER TABLE {TABLE NAME}
8ADD {COLUMN NAME} {DATA TYPE} {NULL | NOT NULL}
9CONSTRAINT {CONSTRAINT NAME} DEFAULT {DEFAULT VALUE}
10
11--Dropping a contraint:
12ALTER TABLE {TABLE NAME}
13DROP CONSTRAINT {CONSTRAINT NAME}