DROP DEFAULT

Remove user-defined default(s) from the current database.

Syntax
      DROP DEFAULT { [schema_name.] default_name } [ ,...n ] [ ; ]

Key:
    schema_name    The schema to which the default belongs
    default_name   Name of an existing default

Defaults must comply with the rules for identifiers.

Examples

DROP DEFAULT price_dflt;

"Small is beautiful” ~ E. F.Schumacher

Related commands

CREATE DEFAULT
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