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 vote340 views1 answer
Oracle sql average
SQL
19 votes331 views6 answers
Sql create table
SQL
0 vote342 views1 answer
Postgresql delete type
SQL
0 vote344 views1 answer
Sqlalchemy get schema from database
SQL
0 vote309 views1 answer
Power query datetime to date
SQL
1 vote321 views1 answer
Tsql random number
SQL
3 votes331 views2 answers
How to modify rows in SQL Server
SQL
0 vote335 views1 answer
Select multiple row from primary key sql
SQL
1 vote322 views1 answer
Create temporal table in sql
SQL
3 votes333 views2 answers
Oracle drop column
SQL