/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

-1 vote340 views3 answers
SQL to LINQ converter
SQL
0 vote338 views1 answer
How to connect sqlalchemy to mysql and deploy it
SQL
2 votes335 views1 answer
Sql count having
SQL
2 votes358 views1 answer
Q operator in sql
SQL
1 vote347 views1 answer
Continue in sql
SQL
2 votes317 views1 answer
Sqlite show table indexes
SQL
1 vote332 views1 answer
Sql server get users
SQL
0 vote359 views1 answer
Alter table add column in SQL Server- NAYCode.com
SQL
0 vote332 views1 answer
Get the Db column names from a SqlDataReader
SQL
0 vote338 views1 answer
Docker export psql sql
SQL