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 vote215 views1 answer
Sql statement show all emails with dome
SQL
4 votes220 views3 answers
Sqlite show columns
SQL
0 vote176 views1 answer
If exist column in table drop sql query mysql
SQL
1 vote239 views1 answer
Oracle drop chain step
SQL
0 vote222 views1 answer
Sql order by number not ordered
SQL
6 votes257 views2 answers
Return columns from table sql
SQL
0 vote199 views1 answer
How to get one year old query from plan cache
SQL
0 vote189 views1 answer
Jenkins SQLCMD run
SQL
2 votes205 views1 answer
Use cases condition in sql query laravel
SQL
0 vote188 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client (SQL: select * from information_schema.tables where table_schema = blog and table_name = migrations and table_type = 'BASE TABL
SQL