/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 vote191 views1 answer
Hw to delete a procedure in pl sql
SQL
0 vote207 views1 answer
Mysqli_connect using prepare statement
SQL
5 votes231 views1 answer
Get column name sql server
SQL
0 vote194 views1 answer
How to check xampp mysql password
SQL
0 vote193 views1 answer
Mysql 1 hour ago
SQL
0 vote200 views2 answers
Mysql to python pandas
SQL
-1 vote213 views1 answer
Capitole toulouse
SQL
5 votes191 views1 answer
Invalid column name sql
SQL
3 votes201 views2 answers
How to start postgresql on windows
SQL
0 vote167 views1 answer
Online sql compiler
SQL