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 vote135 views3 answers
Check table exist postgresql
SQL
0 vote146 views1 answer
Select top 3 sql
SQL
0 vote153 views1 answer
Postgresql log
SQL
0 vote129 views1 answer
How to stop all connections to a psql 12 database?
SQL
0 vote161 views1 answer
Set open file limit mac catalina mysql
SQL
1 vote133 views1 answer
Mysql get character set
SQL
0 vote134 views2 answers
Plsql regex match whole word
SQL
0 vote134 views1 answer
Postgresql alter column nullable
SQL
28 votes140 views6 answers
Mysql change user password
SQL
4 votes131 views3 answers
Sql drop database if exists
SQL