/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 vote234 views1 answer
Postgresql port 5432 not open
SQL
0 vote199 views1 answer
How to remove default in mysql
SQL
0 vote215 views1 answer
Drop all procedures sql server
SQL
0 vote214 views2 answers
How to start postgresql laravel
SQL
0 vote222 views1 answer
Create a table from one field of another table
SQL
19 votes212 views2 answers
Mysql add column after another
SQL
0 vote228 views1 answer
Create table with primary key and foreign key in sql server
SQL
2 votes250 views3 answers
Xampp mysql database not starting
SQL
4 votes281 views1 answer
Oracle table statistics
SQL
21 votes218 views4 answers
Oracle add column
SQL