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

3 votes265 views2 answers
How to View column names of a table in SQL
SQL
12 votes280 views5 answers
Sql merge
SQL
0 vote313 views1 answer
SQL joins in python
SQL
0 vote299 views2 answers
How to prevent sql injection in java
SQL
0 vote270 views1 answer
Get foreign table names mysql
SQL
0 vote298 views1 answer
Display all node label neo4j
SQL
12 votes256 views4 answers
SQL Where
SQL
1 vote265 views1 answer
How to get alternate records from a table in sql
SQL
0 vote272 views1 answer
Sql server remove 0 from left
SQL
0 vote278 views1 answer
Odd record sql query
SQL