/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 vote342 views1 answer
HOW to select specific table data from an mysql databse server:
SQL
0 vote289 views1 answer
T sql dynamic top n query
SQL
0 vote289 views1 answer
Tinydb add table
SQL
1 vote255 views1 answer
Sql get all columns from one table but one from another inner join
SQL
0 vote274 views1 answer
Sqlite to csv statement
SQL
0 vote303 views1 answer
How can I tell how many Cores SQL Server is actually using?
SQL
0 vote252 views2 answers
Sqlite
SQL
0 vote260 views1 answer
Mysql workbench download for iinux mint 19.3
SQL
0 vote266 views1 answer
Sauvegarde complète my sql
SQL
0 vote315 views1 answer
Dual in db2
SQL