/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 vote148 views2 answers
Update query with between in mysql
SQL
3 votes221 views1 answer
Postgresql today - 1 year
SQL
2 votes181 views3 answers
Mysql cheat sheet
SQL
5 votes138 views2 answers
Ranking functions in sql
SQL
0 vote125 views1 answer
Check mysql password with docker container magento 2
SQL
10 votes117 views3 answers
Join multiple tables sql
SQL
0 vote125 views1 answer
Psql check if value in array
SQL
7 votes139 views3 answers
Python and mysql connectivity
SQL
0 vote153 views2 answers
Mysql row_number() example
SQL
15 votes147 views5 answers
Select all tables sql
SQL