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

2 votes225 views1 answer
Mysql cannot delete or update a parent row
SQL
0 vote209 views1 answer
Mysql grouping functions
SQL
0 vote203 views1 answer
Mysql date + 1 day
SQL
0 vote272 views1 answer
Mssql describe stored procedure sqlcmd
SQL
0 vote185 views5 answers
Sql table intermédiaire
SQL
0 vote201 views1 answer
Number(10 2) in sql means
SQL
0 vote201 views1 answer
Postgresql delete limit
SQL
20 votes209 views3 answers
Update values in select statement sql
SQL
2 votes189 views1 answer
Mysql list users on ubuntu
SQL
2 votes206 views2 answers
TSQL GET ALL COLUMNS IN TABLE
SQL