/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

4 votes235 views2 answers
Raise errors.NotSupportedError( mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported
SQL
1 vote214 views1 answer
Add current timestamp in mysql
SQL
5 votes242 views1 answer
Get table columns from sql
SQL
0 vote166 views1 answer
Prevent duplicate rows in postgres
SQL
1 vote195 views1 answer
What is intersect
SQL
3 votes191 views1 answer
Sql multiple column index
SQL
0 vote217 views2 answers
Collation in sql
SQL
1 vote196 views1 answer
Woocommerce mysql price table
SQL
2 votes246 views1 answer
Sql string starts with
SQL
0 vote214 views1 answer
Criteria builder select subset of column
SQL