/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 votes121 views2 answers
Mysql on duplicate key ignore
SQL
1 vote119 views1 answer
Mysqli connect
SQL
0 vote238 views1 answer
Sql server query all database objects
SQL
0 vote176 views1 answer
Mysql error 1114 (hy000) the table is full
SQL
0 vote123 views1 answer
Components/Fields of Internal Table
SQL
0 vote129 views1 answer
Error: connect ECONNREFUSED 127.0.0.1:5432 at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1148:16
SQL
1 vote121 views1 answer
Substr sql last character
SQL
3 votes138 views2 answers
Find string in stored procedure sql server
SQL
1 vote126 views1 answer
Sql select row with max date
SQL
2 votes125 views1 answer
Cast string to datetime mysql
SQL