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

2 votes185 views1 answer
Oracle sql drop column if exists
SQL
0 vote222 views1 answer
How to find database collation in postgres
SQL
4 votes239 views4 answers
Start mysql
SQL
0 vote226 views3 answers
Postgresql allow remote connections
SQL
0 vote249 views2 answers
How to count codition
SQL
0 vote265 views1 answer
For select oracle
SQL
0 vote233 views1 answer
Create database like
SQL
0 vote225 views1 answer
Oracle allow space to user
SQL
4 votes227 views1 answer
Change nls_date_format
SQL
2 votes236 views1 answer
Sqlplus clear screen
SQL