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 votes306 views2 answers
Oracle no data found error code
SQL
2 votes323 views1 answer
Mysql last 7 days including today
SQL
15 votes333 views4 answers
Mysql export database command line
SQL
0 vote327 views1 answer
Set default value now() date
SQL
5 votes309 views1 answer
How to check port number for postgresql
SQL
0 vote320 views1 answer
Postgresql in vs any performance
SQL
0 vote312 views2 answers
Csv into data postgres
SQL
2 votes326 views1 answer
Sql finding longest and shortest names in a fleld
SQL
18 votes267 views2 answers
How to get all the tables displayed in oracle
SQL
1 vote326 views1 answer
Mysql size int
SQL