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

17 votes286 views4 answers
Sort by mysql
SQL
0 vote281 views1 answer
Run mysql xampp shell
SQL
0 vote271 views1 answer
Call procedure in wordpress
SQL
0 vote286 views1 answer
PDOException: SQLSTATE[HY093]: Invalid parameter numb
SQL
3 votes258 views2 answers
Oracle for loop
SQL
0 vote284 views1 answer
Resullt all update knex mysql
SQL
0 vote253 views1 answer
Get duplicate entry sql
SQL
0 vote271 views1 answer
Sql server sleep
SQL
0 vote260 views1 answer
SQL Server modify_timestamp trigger
SQL
0 vote266 views1 answer
Soql update query
SQL