/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

2 votes137 views2 answers
Create empty table from existing table
SQL
0 vote181 views1 answer
Drop view sql
SQL
0 vote131 views1 answer
Linebreak sql
SQL
3 votes144 views2 answers
How to force truncate a table in mysql
SQL
17 votes134 views3 answers
Postgresql version command
SQL
2 votes154 views1 answer
Revokeprivileges mysql
SQL
0 vote132 views1 answer
Sql select merge multiple values
SQL
1 vote145 views1 answer
SQl Server Versionen Releases und Build-Nummern
SQL
0 vote134 views1 answer
Migration graphql
SQL
2 votes182 views2 answers
Create table mysql integer NOT null
SQL