/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 vote196 views1 answer
Drop view sql
SQL
1 vote165 views1 answer
Opensuse restart MySQL
SQL
14 votes143 views4 answers
Sql compiler
SQL
0 vote154 views1 answer
Mysql change innodb to myisam
SQL
0 vote154 views1 answer
How to get nth number in sql
SQL
4 votes151 views5 answers
Primary key
SQL
1 vote135 views1 answer
Substr sql last character
SQL
1 vote187 views1 answer
Sql oracle update multiple rows
SQL
6 votes133 views2 answers
Oracle
SQL
1 vote140 views1 answer
Mysql get domain from url
SQL