/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 vote308 views1 answer
Use where instead of join
SQL
1 vote315 views1 answer
Show per page table in xampp
SQL
0 vote314 views1 answer
How to select even id in sql
SQL
0 vote336 views1 answer
Postgres can integer fields be negative
SQL
18 votes322 views4 answers
Mysql current date between two dates
SQL
5 votes354 views1 answer
Get column name sql server
SQL
0 vote297 views1 answer
Mysql auto increment in DD-MM-XXX format
SQL
1 vote297 views1 answer
Mysql column start with string
SQL
-1 vote317 views1 answer
How to switch user in mysql
SQL
0 vote330 views2 answers
Postgresql gset
SQL