/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 vote323 views1 answer
PSQL qith variables
SQL
0 vote325 views1 answer
Cast as decimal postgresql
SQL
0 vote312 views1 answer
Remove from table where
SQL
1 vote379 views1 answer
Drop colum oracle 18c
SQL
0 vote313 views1 answer
Which is the order of precedence among following operator IN OUT AND OR in sql
SQL
1 vote360 views2 answers
Oracle difference between two dates in seconds
SQL
0 vote358 views4 answers
Open mysql port bitnami tomact
SQL
1 vote316 views2 answers
Pl sql case
SQL
7 votes380 views2 answers
How to create index mysql
SQL
0 vote312 views1 answer
Oracle right characters
SQL