/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

7 votes200 views1 answer
Return insert results in POSTGRESQL
SQL
0 vote183 views1 answer
Pip install mysqlclient error
SQL
-1 vote187 views1 answer
Mysql case when multiple conditions
SQL
0 vote187 views2 answers
Get top 1 row of each group
SQL
0 vote181 views1 answer
Psql use query result convert Decimal python numpy psycopg2
SQL
10 votes200 views2 answers
What is database
SQL
1 vote191 views1 answer
Wordpress change http to https phpmyadmin
SQL
8 votes213 views2 answers
Update sql server from another table
SQL
0 vote176 views1 answer
Increment id in mysql
SQL
4 votes224 views1 answer
Sql select limit range
SQL