Default constraint in ms sql

/*Alter an existing column to add a default constraint*/
ALTER TABLE (Table_Name)
ADD CONSTRAINT (Constraint_Name)
DEFAULT (Default_Value) FOR (Existing_Column_Name)

Default constraint in ms sql

/*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)

Similar codes

13 votes195 views11 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysql.sock' (2) Ask
SQL
0 vote185 views2 answers
Sql 2 way of select unique
SQL
0 vote159 views1 answer
Dump multiple tables mysql
SQL
1 vote178 views2 answers
Begin transaction in sql
SQL
1 vote237 views1 answer
Ora-01950 no privileges on tablespace
SQL
1 vote184 views5 answers
Postgresql difference between two dates in days
SQL
2 votes168 views1 answer
Install sqlite npm
SQL
0 vote192 views1 answer
How to add unique key constraint in mysql
SQL
14 votes174 views5 answers
Sql oracle limit
SQL
2 votes233 views2 answers
Postgres set user as superuser
SQL