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

4 votes320 views1 answer
Oracle change nls_date_format permanently
SQL
0 vote317 views1 answer
MySql count occurences more than"
SQL
0 vote333 views1 answer
Ignore case in string sql
SQL
58 votes643 views6 answers
Create new user in postgres
SQL
7 votes320 views1 answer
Mysql unsafe update
SQL
0 vote368 views1 answer
Mysql where don't have string
SQL
1 vote369 views2 answers
Oracle difference between two dates in seconds
SQL
0 vote337 views1 answer
Find invalid datetime field
SQL
10 votes321 views4 answers
Primary key sql
SQL
0 vote338 views1 answer
How to find username and password in oracle 18c
SQL