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

19 votes294 views6 answers
Sql drop table if exists
SQL
2 votes284 views1 answer
Oracle drop table free up space
SQL
0 vote292 views1 answer
Sql server select record with max id
SQL
0 vote281 views1 answer
How to concatenate text from multiple rows into a single text string in SQL Server
SQL
1 vote279 views1 answer
Lpad function in sql oracle
SQL
0 vote287 views1 answer
Mysql cast null to string
SQL
0 vote290 views2 answers
Select columns from 2 tables with foreign key
SQL
1 vote284 views1 answer
Import sql file mysql commadn line
SQL
0 vote276 views1 answer
How to check default value of column in sql server
SQL
-1 vote288 views3 answers
SQL to LINQ converter
SQL