/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

0 vote340 views1 answer
Provera dupliranih konatakata
SQL
1 vote350 views1 answer
Decalre temp table sql
SQL
0 vote387 views2 answers
Insert data mysql with cmd
SQL
22 votes342 views6 answers
Create sql table
SQL
33 votes427 views6 answers
Sql delete
SQL
-1 vote347 views1 answer
Convert google analytics dathourminute to time stamp? sql
SQL
4 votes412 views1 answer
Fatal error: libpq-fe.h: No such file or directory
SQL
11 votes351 views2 answers
Turn off safe mode mysql
SQL
0 vote364 views3 answers
How to increase size of column in sql
SQL
1 vote360 views1 answer
Tsql get beginning of year
SQL