/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

50 votes202 views6 answers
Install mysql on ubuntu
SQL
4 votes109 views1 answer
Sql delete multiple conditions
SQL
8 votes104 views1 answer
Today minus 15 days postgresql
SQL
1 vote115 views2 answers
Snowflake alter column data type
SQL
0 vote157 views1 answer
Sqlite send a query to a Sqlite DB with Ruby
SQL
1 vote117 views1 answer
Install postgresql on raspberry pi
SQL
4 votes122 views2 answers
Float postgres
SQL
1 vote97 views1 answer
Foreign key constraint in ms sql
SQL
0 vote116 views1 answer
Alter owner in PostgreSQL
SQL
0 vote111 views1 answer
SQL Server modify_timestamp trigger
SQL