.NET Programming With Me

SQL Server - alter column - adding default constraint

The following sql syntax is used for adding a default value constraint to a column in the table already created.

alter table <TableName>
  add constraint <df_ConstraintName>
  default <defaultValue> for <columnName>

Example:
alter table employee
  add constraint df_empSalary
  default 0 for empSalary

No comments: