/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

2 votes237 views1 answer
Show max_allowed_packet mysql
SQL
1 vote202 views1 answer
Display total number of tables in mysql
SQL
0 vote195 views1 answer
Sql find all different values in column
SQL
0 vote191 views1 answer
Top frequency in sql server
SQL
0 vote188 views1 answer
Mysql convert charset
SQL
2 votes212 views1 answer
Drop sequence
SQL
0 vote195 views1 answer
Soql update query
SQL
0 vote190 views2 answers
Create row number in sql
SQL
0 vote219 views1 answer
Oracle winter time change
SQL
1 vote205 views1 answer
Mysql select from outside
SQL