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 vote347 views3 answers
Mariadb add foreign key
SQL
0 vote419 views1 answer
Connect google bigquery connect using sqirrel
SQL
2 votes377 views1 answer
Datetrunc
SQL
0 vote352 views1 answer
How to find sql server name
SQL
10 votes429 views6 answers
Mysql set root password
SQL
0 vote377 views1 answer
Get id if is not equal in certain table
SQL
0 vote364 views1 answer
Mysql query problems and solutions
SQL
0 vote348 views1 answer
Porcentaje sql
SQL
1 vote359 views1 answer
Get count by weekly pivot table sql server
SQL
11 votes346 views2 answers
Docker create postgres db
SQL