A default specifies the value to be inserted into a column whenever no value is supplied.
This command will be removed in a future version of SQL Server. Avoid using this command in new development work, and plan to modify any application that currently uses it.
Syntax CREATE DEFAULT [schema.] default_name
AS constant_expression [;] Key: default_name Name of the default. constant_expression An expression containing only constant values
You can create a DEFAULT definition as part of the table definition when you create a table. If a table already exists, you can add a DEFAULT definition to it. Each column in a table can contain one DEFAULT definition.
"Small is beautiful" - E. F.Schumacher
sp_help - List the defaults that exist
sp_unbindefault - Unbind the default from a column or an alias data type.
Equivalent Oracle command:
ALTER TABLE ... DEFAULT