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.

Example

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