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 vote172 views1 answer
Running percentage of total postgres
SQL
0 vote347 views1 answer
Redirection 301 htaccess nom de domaine
SQL
0 vote153 views3 answers
Group_concat sql server
SQL
16 votes175 views1 answer
Sql comment'
SQL
5 votes190 views4 answers
Mysql on duplicate key update
SQL
8 votes142 views2 answers
Phpmyadmin default password
SQL
1 vote147 views1 answer
Simple project for database
SQL
0 vote155 views1 answer
Mysql workbench primary key
SQL
0 vote155 views1 answer
Query to get all primary keys and foreign key
SQL
5 votes183 views2 answers
Functions
SQL