/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

1 vote290 views1 answer
Blob datatype in mysql
SQL
2 votes304 views2 answers
Mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]
SQL
2 votes278 views2 answers
How to get capital letter first in sql
SQL
1 vote266 views1 answer
Limit offset order by mysql
SQL
0 vote266 views1 answer
How many columns can be used for creating index?
SQL
0 vote276 views1 answer
Data types mysql vs postgresql
SQL
0 vote309 views1 answer
TSQL Code Snippet For Optimized Sales Query
SQL
0 vote280 views1 answer
Uncaught Error: Call to undefined function DatabaseOld\mysqli_connect()
SQL
1 vote285 views1 answer
Sql first
SQL
0 vote269 views1 answer
Power query datetime to date
SQL