/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 vote132 views1 answer
Mysql regex select
SQL
4 votes116 views1 answer
Mysql copy table with new name
SQL
1 vote159 views1 answer
Postgresql append array
SQL
0 vote127 views1 answer
Select year from dual oracle
SQL
0 vote124 views1 answer
T sql return on letters only
SQL
3 votes130 views2 answers
Postgresql select all column names
SQL
4 votes109 views3 answers
Sql drop database if exists
SQL
0 vote179 views1 answer
Postgresql powershell query
SQL
0 vote115 views1 answer
Qt qsql check if table exist
SQL
0 vote115 views1 answer
Top frequency in sql server
SQL