/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 vote234 views1 answer
Get all db sizes in mysql server
SQL
1 vote233 views1 answer
Sql select contem uma palavra
SQL
-1 vote210 views2 answers
Sql server date format yyyy-MM-ddThh:mm:ss
SQL
3 votes215 views4 answers
Show columns from table
SQL
0 vote244 views1 answer
Sql find all different values in column
SQL
2 votes254 views1 answer
Sqlplus clear screen
SQL
2 votes257 views1 answer
Rails execute sql
SQL
1 vote249 views1 answer
Create new index takes long time postgresql
SQL
11 votes227 views2 answers
MySQL DISTINCT
SQL
0 vote248 views1 answer
Duplix print in Smartforms
SQL