/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 vote172 views1 answer
Regular expression in sql server
SQL
0 vote221 views1 answer
Retornar apenas o ano mysql date
SQL
37 votes395 views3 answers
Sql check duplicate value in column
SQL
0 vote207 views1 answer
How to get table id sequence postgres
SQL
7 votes179 views2 answers
Html to react converter
SQL
0 vote184 views1 answer
CALCULATING MONTHS BETWEEN TWO DATES IN POSTGRESQL
SQL
1 vote179 views1 answer
Oracle update with sequence
SQL
0 vote195 views1 answer
Recently updated stored procedure in sql server
SQL
5 votes183 views2 answers
Mysql import gzip db
SQL
0 vote196 views1 answer
Mysql get nth highest
SQL