/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 vote405 views1 answer
Oracle decode
SQL
1 vote364 views1 answer
How to fetch alternate records from two tables
SQL
1 vote369 views1 answer
Sql headers delphi
SQL
-1 vote331 views1 answer
Sql getdate date only
SQL
0 vote351 views1 answer
Selecting all columns from table sql database
SQL
0 vote363 views1 answer
Mysql date format unix timestamp
SQL
5 votes363 views1 answer
Oracle add time to date
SQL
0 vote343 views1 answer
Postgres sql alter table delete row
SQL
34 votes417 views6 answers
Alter table add foreign key mysql
SQL
1 vote343 views1 answer
Raw query must include primary key
SQL