/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 votes224 views2 answers
Mysql compare datetime to another datetime
SQL
1 vote160 views1 answer
STOP message of how many rows affected sql
SQL
9 votes149 views2 answers
Sql limit order by
SQL
0 vote157 views1 answer
Sql select rows with different values in one column
SQL
-2 votes157 views1 answer
Remove root password mysql
SQL
0 vote170 views1 answer
Except in sql
SQL
3 votes145 views2 answers
Update Query in SQL Server
SQL
0 vote203 views1 answer
SQL Server Altering Column to be Unique
SQL
15 votes190 views3 answers
Create table with primary key auto increment in sql
SQL
1 vote168 views2 answers
Remove space in mysql
SQL