/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

0 vote258 views1 answer
Sqlite update where exists
SQL
0 vote292 views1 answer
Oracle db get table sizes
SQL
1 vote194 views1 answer
Sql pick random row
SQL
92 votes2.3K views6 answers
Substring
SQL
1 vote223 views1 answer
Postgresql not in
SQL
2 votes203 views1 answer
Mysql create user with mysql_native_password
SQL
-1 vote175 views3 answers
Mysql get age from date
SQL
16 votes257 views4 answers
Find duplicates mysql
SQL
0 vote195 views1 answer
Contact mysql column field
SQL
0 vote152 views1 answer
Now() -1 mysql
SQL