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 votes141 views1 answer
No data found oracle
SQL
0 vote143 views2 answers
How to update the multiple rows in sql
SQL
19 votes131 views1 answer
Sqrt(-1)
SQL
8 votes163 views4 answers
Reset SQL auto increment
SQL
0 vote135 views1 answer
How to get n result in sql
SQL
1 vote144 views2 answers
Datetrunc hour snowflake
SQL
1 vote129 views1 answer
Oracle sql create view
SQL
0 vote136 views1 answer
Selects all the columns from the sailors table
SQL
1 vote134 views1 answer
Psql show with user is logged in
SQL
0 vote131 views1 answer
Sequelize postgresql schema
SQL