/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

1 vote339 views1 answer
Db.Database.SqlQuery
SQL
2 votes342 views1 answer
How to check if a row is null in sql
SQL
1 vote285 views1 answer
Select from one table where not on the other
SQL
1 vote330 views2 answers
Intersect sql
SQL
0 vote302 views1 answer
Update having mysql
SQL
1 vote283 views1 answer
Base nosql
SQL
3 votes316 views3 answers
Mysql declare variable
SQL
0 vote281 views1 answer
Mysql auto increment in DD-MM-XXX format
SQL
1 vote295 views1 answer
How to unlock table in mysql
SQL
0 vote297 views1 answer
Oracle step procedure
SQL