/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

2 votes116 views1 answer
Oracle find unusable indexes
SQL
0 vote132 views1 answer
Why do we need data structure in sql
SQL
0 vote163 views1 answer
HOW to select specific table data from an mysql databse server:
SQL
0 vote122 views1 answer
Create a table from one field of another table
SQL
0 vote108 views1 answer
How to count null values in sql
SQL
0 vote106 views1 answer
Search db for table name
SQL
3 votes117 views4 answers
Mysql decimal
SQL
9 votes113 views2 answers
Sql limit order by
SQL
0 vote118 views1 answer
MySQL FIND_IN_SET()
SQL
1 vote72 views1 answer
Mysql see column types
SQL