/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 vote190 views1 answer
Qt qsql check if table exist
SQL
1 vote203 views2 answers
Full join
SQL
0 vote189 views1 answer
Adding primery key constraint to a column
SQL
11 votes198 views2 answers
Oracle saurce code
SQL
7 votes309 views2 answers
Mysql default value
SQL
33 votes187 views6 answers
Sql delete
SQL
0 vote183 views1 answer
An error occurred while installing mysql2 (0.5.3)
SQL
0 vote190 views1 answer
Google sheets filter rows above current cell
SQL
40 votes263 views4 answers
PostgreSQL add column
SQL
0 vote221 views1 answer
Find wordpress version in database
SQL