/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 vote202 views1 answer
Convert rows into columns in oracle
SQL
16 votes243 views3 answers
T-SQL Add Column
SQL
0 vote207 views1 answer
How to use select union and loop
SQL
0 vote209 views1 answer
How to import pymysql through jupyter notebook for windows
SQL
-1 vote285 views1 answer
Sql vs nosql or mysql vs mongodb
SQL
17 votes214 views6 answers
Change column name in sql
SQL
2 votes183 views1 answer
Sql find missing values between two tables
SQL
0 vote193 views1 answer
Import mysql'
SQL
2 votes220 views1 answer
Sql finding longest and shortest names in a fleld
SQL
0 vote211 views1 answer
SQL Server Enterprise
SQL