/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 vote304 views1 answer
How to select rows with no matching entry in another table?
SQL
3 votes350 views2 answers
Synonym oracle
SQL
0 vote312 views1 answer
Postgresql get diff between two dates in Months
SQL
1 vote298 views1 answer
Create procedure with encryption
SQL
4 votes300 views1 answer
Sql delete where in select
SQL
0 vote380 views1 answer
Split first name and last name in sql
SQL
0 vote432 views1 answer
ORA-01400
SQL
-1 vote299 views1 answer
Add column alter table default value
SQL
0 vote313 views1 answer
Adding primery key constraint to a column
SQL
0 vote299 views1 answer
Capture Image Store Image in Folder and image Path in sqlite Database
SQL