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 vote104 views2 answers
Sql server add time to date
SQL
1 vote58 views1 answer
Ms sql how to see active job current run time
SQL
0 vote149 views1 answer
Sql check if field is not null
SQL
19 votes104 views5 answers
Change column name mysql command line
SQL
1 vote107 views1 answer
Psql connections
SQL
1 vote104 views1 answer
Mysql check table exists
SQL
-2 votes127 views1 answer
Mysql not empty
SQL
0 vote110 views1 answer
Mysql listing get a particu particular user firsdt
SQL
17 votes231 views4 answers
Show all tables in oracle
SQL
0 vote99 views2 answers
Mysql password error create datbase
SQL