 Create Default
CREATE DEFAULT
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. |