/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 vote243 views2 answers
Backup table mssql
SQL
0 vote215 views1 answer
Wordpress sql change site url
SQL
0 vote223 views1 answer
Mysql change timestamp on update
SQL
3 votes227 views3 answers
Concatenation in sql
SQL
0 vote270 views1 answer
Copy from one table to another postgres using matching column
SQL
0 vote261 views1 answer
Dual in db2
SQL
3 votes232 views1 answer
Oracle apex warn on unsaved changes
SQL
4 votes235 views1 answer
Mysql copy table with new name
SQL
0 vote231 views1 answer
Error Code: 1140. In aggregated query without GROUP BY, expression #3 of SELECT list contains nonaggregated column 'grepper_history.search_history.term'; this is incompatible with sql_mode=only_full_group_by
SQL
15 votes225 views4 answers
T-sql drop function if exists
SQL