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.

      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

Related commands

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

Copyright © 1999-2023
Some rights reserved