The ListBoundDatatypes method returns a SQLObjectList object enumerating the user-defined data types to which a rule or default is bound.
| Default Object | Rule Object |
object.ListBoundDatatypes( ) as SQLObjectList
| Part | Description |
|---|---|
| object | Expression that evaluates to an object in the Applies To list |
A SQLObjectList object containing 0 or more UserDefinedDatatype objects.
A SQL Server default or rule cannot be dropped when bound to a SQL Server object.
For the Default or Rule object, you can use the ListBoundDatatypes method to enumerate user-defined data type bound, then use the Name property of UserDefinedDatatype objects returned and the UnbindFromDatatype method of the object to remove bindings.
A SQL Server default or rule can be bound to a column. Use the ListBoundColumns and UnbindFromColumn method to remove bindings on a column.
HRESULT ListBoundDatatypes(
LPSQLDMOUSERDEFINEDDATATYPELIST* ppList);