/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 vote357 views3 answers
Psql get last rows
SQL
0 vote339 views1 answer
How to remove default in mysql
SQL
32 votes383 views6 answers
Sql count where
SQL
1 vote337 views1 answer
Mysqldump: couldn't execute 'select column_name,
SQL
1 vote371 views2 answers
Sql for date greater than
SQL
0 vote366 views1 answer
Hotw to alter lengh character vayng postgres
SQL
2 votes368 views1 answer
How to check grants on a package in oracle
SQL
1 vote352 views1 answer
Importance of comment in mysql
SQL
1 vote347 views1 answer
Mysql get character set
SQL
11 votes399 views5 answers
Laravel db facade
SQL