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

8 votes316 views3 answers
Alter user root mysql
SQL
0 vote317 views3 answers
How to run sql query
SQL
0 vote313 views4 answers
Mysql count table rows
SQL
2 votes299 views1 answer
Drop table purge
SQL
3 votes319 views2 answers
Sql server current date without time
SQL
1 vote251 views1 answer
Mysql see column types
SQL
8 votes296 views5 answers
Alter table add column with default value
SQL
3 votes310 views2 answers
Get current year sql
SQL
0 vote312 views1 answer
How to Remove milliseconds from Date time
SQL
0 vote309 views1 answer
Postgresql certain first 4 characters in string
SQL