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 votes161 views1 answer
Create table with primary key
SQL
6 votes170 views1 answer
Check Table Exists
SQL
0 vote170 views1 answer
Csv to sqlite python
SQL
19 votes142 views1 answer
Sqrt(-1)
SQL
10 votes163 views1 answer
Oracle dependency
SQL
1 vote161 views1 answer
Postgres check blocking
SQL
0 vote160 views1 answer
Database springboot
SQL
0 vote187 views1 answer
Procedures sql insert mysql
SQL
5 votes136 views1 answer
Postgres upsert
SQL
0 vote189 views1 answer
Migration graphql
SQL