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

1 vote200 views1 answer
Tsql find foreign key references
SQL
0 vote191 views1 answer
Mariadb errno 121
SQL
5 votes248 views4 answers
Rollback to in sql
SQL
-2 votes198 views3 answers
Sqlite reset autoincrement
SQL
3 votes192 views2 answers
Sql add year to date
SQL
2 votes318 views1 answer
Mysql create user with remote access
SQL
0 vote206 views8 answers
Convert sql query to linq online
SQL
18 votes194 views3 answers
Find column name in database
SQL
2 votes360 views5 answers
Unique in sql server
SQL
0 vote182 views1 answer
Sql server split string and insert into table select
SQL