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

0 vote117 views1 answer
Mysql Install Ubuntu with native password
SQL
18 votes149 views2 answers
Find all tables containing column with specified name - MS SQL Server
SQL
0 vote91 views1 answer
Store query result in variable sql
SQL
0 vote125 views1 answer
Oracle archivelog usage
SQL
26 votes133 views2 answers
Mysql workbench download
SQL
1 vote128 views1 answer
Add many column to sap iq table
SQL
4 votes133 views2 answers
Postgresql default value
SQL
1 vote123 views3 answers
Union SQL
SQL
0 vote118 views1 answer
Myswql show full processlist
SQL
1 vote145 views1 answer
Insert value to new table by joining 2 different tables
SQL