/SQL/Adding a default constraint to an existing column in sql

Adding a default constraint to an existing column in sql

--Altering an existing column to add a default constraint:
ALTER TABLE {TABLE NAME}
ADD CONSTRAINT {CONSTRAINT NAME}
DEFAULT {DEFAULT VALUE} FOR {EXISTING COLUMN NAME}

--Adding a new column, with default value, to an existing table:
ALTER TABLE {TABLE NAME}
ADD {COLUMN NAME} {DATA TYPE} {NULL | NOT NULL}
CONSTRAINT {CONSTRAINT NAME} DEFAULT {DEFAULT VALUE}

--Dropping a contraint:
ALTER TABLE {TABLE NAME}
DROP CONSTRAINT {CONSTRAINT NAME}

Similar codes

0 vote271 views1 answer
Multiple row join
SQL
4 votes130 views2 answers
Insert current date in mysql
SQL
8 votes183 views6 answers
Insert command in sql
SQL
1 vote134 views1 answer
Update from select join
SQL
13 votes151 views2 answers
Sql join 3 tables
SQL
0 vote139 views1 answer
Sql developer connect to sql server
SQL
47 votes213 views6 answers
Add column mysql
SQL
0 vote144 views1 answer
Postgresql in vs any performance
SQL
1 vote142 views1 answer
Mysql f# examples
SQL
0 vote135 views1 answer
Mysql where don't have string
SQL