/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 vote203 views1 answer
Select last row from SQL Table
SQL
0 vote207 views1 answer
Varchar2 length in oracle
SQL
16 votes153 views1 answer
Mysql reset auto increment value
SQL
1 vote162 views1 answer
Age postgres
SQL
1 vote188 views1 answer
Apex run 404
SQL
1 vote182 views1 answer
Add sequence postgres
SQL
3 votes157 views2 answers
Postgres show table schema
SQL
0 vote223 views1 answer
How to get number of months between 2 dates sql server
SQL
0 vote154 views1 answer
MQL4 mql4 run ea on all symbols by adding to just one chart
SQL
0 vote170 views3 answers
Find below average salary in sql
SQL