/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 vote260 views1 answer
Teller stamp , bmo , PDF
SQL
0 vote230 views1 answer
Mysql create table columns with spaces
SQL
0 vote262 views1 answer
Select insert new table sql server
SQL
3 votes264 views2 answers
Java.sql.SQLException: Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property.
SQL
1 vote258 views1 answer
How to group by month using sql server
SQL
0 vote304 views1 answer
How to use mysql_tzinfo_to_sql on windows
SQL
1 vote248 views1 answer
Type int in mysql maxlenght
SQL
0 vote305 views1 answer
Sql alternative to max statement
SQL
0 vote266 views1 answer
How to get data from 2 database
SQL
8 votes292 views1 answer
Mysql dump restore
SQL