UnbindFromDatatype Method

SQLServer.Database.Default Object

Description

Breaks an existing binding between a default and a user-defined datatype.

Visual Basic

Default.UnbindFromDatatype (
[DatatypeName :=] idDatatype,
[[FutureOnly :=] bFutureOnly] )

C++

HRESULT pDefault->UnbindFromDatatype (
SQLOLE_LPCSTR idDatatype,
BOOL bFutureOnly = FALSE );

Elements

Element Type Description

idDatatype Identifer User-defined datatype
bFutureOnly Boolean Determines if existing columns of the specified datatype are prevented from losing the old default. If True, existing columns keep the old default. If False, existing columns lose the old default. The default is False.

Reference

sp_unbindefault