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: