/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 vote314 views1 answer
Type int in mysql maxlenght
SQL
1 vote344 views1 answer
Oracle difference between two dates in years
SQL
1 vote331 views1 answer
Oracle update with sequence
SQL
0 vote352 views1 answer
Oracle current date minus 1 day
SQL
5 votes321 views1 answer
Alter table add comment oracle
SQL
1 vote329 views1 answer
Moodle query item quiz
SQL
0 vote304 views1 answer
Version and edition of SQL Server Database Engine
SQL
0 vote340 views1 answer
T sql dynamic top n query
SQL
1 vote342 views1 answer
Mysql datetime with timezone offset
SQL
0 vote304 views1 answer
Ms Sql set us timezone
SQL