/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 vote161 views1 answer
Mariadb cast to int
SQL
0 vote170 views1 answer
Mssql check if date is greater than today
SQL
17 votes218 views6 answers
Sql current date
SQL
5 votes172 views1 answer
Oracle get foreign keys on table
SQL
0 vote171 views1 answer
Sql server list table sizes
SQL
11 votes125 views1 answer
Reset identity sql server
SQL
14 votes176 views2 answers
Install mysqldump
SQL
2 votes163 views1 answer
Oracle virtual column
SQL
1 vote185 views1 answer
Spark sql convert string to date
SQL
1 vote188 views1 answer
Moodle query first user access
SQL