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;

__________________
The KINGMAKER
Makes Every Thing Possible

Stuffs (My Blog)