/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 vote104 views1 answer
T-sql check if data exists
SQL
1 vote105 views1 answer
Incompatible sql_mode=only_full_group_by
SQL
0 vote101 views1 answer
Duplicate value unique constraint mysql error
SQL
0 vote98 views1 answer
Psql select * from table
SQL
1 vote108 views1 answer
Sql try catch
SQL
17 votes113 views2 answers
T_sql contains
SQL
0 vote122 views1 answer
Sql server create constraint
SQL
0 vote95 views1 answer
Postgres: Create Column add constraint to the column with Query Output
SQL
0 vote126 views1 answer
INSERT INTO GBP Plus(Index Change) VALUES( AND((SELECT NUMINDEX FROM GBP WHERE ID>ID-1) - (SELECT NUMINDEX FROM GBP WHERE ID=ID ))
SQL
4 votes101 views2 answers
Select first and last row mysql
SQL