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

0 vote186 views1 answer
Edit a field mysql terminal
SQL
10 votes154 views2 answers
Django mysql
SQL
-1 vote190 views1 answer
Extract Data from SQL Server into XML Format
SQL
0 vote221 views1 answer
How do I insert a blob in SQL?
SQL
1 vote201 views1 answer
Access the postgres psql
SQL
1 vote199 views1 answer
Mariadb get column names from table
SQL
7 votes212 views2 answers
Sql server drop temp table if exists
SQL
1 vote226 views1 answer
Oracle dbms scheduler repeat interval every 5 minutes
SQL
0 vote251 views1 answer
Find duplicate users by email address in mysql
SQL
0 vote208 views1 answer
How to print records of employees hired in particular month in oracle
SQL