/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

11 votes164 views1 answer
How to get ddl for materialized view
SQL
1 vote209 views1 answer
Nullif postgresql
SQL
0 vote183 views1 answer
SQL COMO ALTERA NOME DE TABELA
SQL
2 votes224 views1 answer
Create delete procedure mysql
SQL
6 votes194 views1 answer
How to get the size of the database in postgresql
SQL
0 vote181 views1 answer
Mysql get last 2 month data
SQL
0 vote182 views1 answer
Flask sqlalchemy session delete
SQL
1 vote169 views1 answer
Is sql fast
SQL
0 vote171 views1 answer
Oracle date winter time
SQL
5 votes179 views1 answer
Oracle sysdate - 1 month
SQL