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 vote185 views1 answer
Copy Table from SQL to CSV
SQL
0 vote185 views1 answer
What is between keyword used for
SQL
0 vote189 views1 answer
Query by column for substring sql
SQL
-1 vote181 views1 answer
How to switch user in mysql
SQL
0 vote176 views1 answer
First mysql
SQL
0 vote183 views1 answer
Mysql user set plugin
SQL
0 vote183 views1 answer
PostgreSQL types and C# types
SQL
3 votes189 views3 answers
Mysql select table names
SQL
0 vote178 views1 answer
Vbscript create ADODB.Connection
SQL
2 votes219 views2 answers
Sql query to list all tables in a database sql server
SQL