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 votes487 views5 answers
Unique in sql server
SQL
0 vote320 views1 answer
Postgresql like
SQL
4 votes314 views1 answer
Data types in sql
SQL
0 vote379 views1 answer
Create view in sql server that contain multiple select statements
SQL
1 vote301 views1 answer
Oracle select first result
SQL
0 vote306 views2 answers
How to install mssql on mac
SQL
0 vote308 views1 answer
Sql common columns
SQL
0 vote285 views1 answer
ORACLE SUBSTRING SYNTAX
SQL
0 vote272 views1 answer
Mysql select row with min date
SQL
0 vote298 views1 answer
How to get distinct sets of rows using SQL (Oracle)?
SQL