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 vote197 views1 answer
Oracle sql listagg
SQL
0 vote207 views1 answer
List all permissions on a table in postgres
SQL
7 votes202 views1 answer
Oracle pagination query rownum
SQL
3 votes183 views1 answer
Select without null values sql
SQL
0 vote190 views1 answer
Access mysql database docker container shell
SQL
3 votes202 views2 answers
Postgres show table schema
SQL
0 vote189 views1 answer
Capture Image Store Image in Folder and image Path in sqlite Database
SQL
1 vote184 views1 answer
SQLSTATE[HY000] [2002]
SQL
4 votes199 views1 answer
Id increment ms sql server
SQL
2 votes220 views2 answers
Asp.net core with postgresql deploy on ubuntu
SQL