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

5 votes131 views1 answer
Mysql count lines
SQL
0 vote130 views1 answer
Pagination with row_number
SQL
0 vote122 views1 answer
Order by monthly in sql
SQL
1 vote119 views1 answer
Can we drop a primary key
SQL
7 votes142 views6 answers
Group_concat in mysql
SQL
0 vote128 views1 answer
Luu ckeditor vao mysql
SQL
1 vote136 views1 answer
Declare variables sql
SQL
1 vote121 views2 answers
Into sql
SQL
0 vote140 views1 answer
Check for directory in bash
SQL
1 vote130 views1 answer
Job for mariadb.service failed because the control process exited with error code. see "systemctl status mariadb.service" and "journalctl -xe" for details.
SQL