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

0 vote242 views1 answer
Mysql order by rand limit 1 really slow
SQL
0 vote223 views1 answer
Stored function in sql
SQL
12 votes213 views4 answers
Import mysql database command line linux
SQL
0 vote203 views1 answer
Select only one row sql
SQL
0 vote177 views0 answer
SQL
11 votes211 views2 answers
MySQL DISTINCT
SQL
0 vote205 views1 answer
Oracle get running queries
SQL
5 votes270 views2 answers
How to ascending order in sql
SQL
1 vote215 views1 answer
How to install mysql 8.0 windows service
SQL
19 votes185 views1 answer
Sqrt(-1)
SQL