Share via


ListBoundColumns Method

Microsoft SQL Server의 이후 버전에서는 이 기능이 제거됩니다. 새 개발 작업에서는 이 기능을 사용하지 말고, 현재 이 기능을 사용하는 응용 프로그램은 수정하십시오.

The ListBoundColumns method returns a SQLObjectList object that enumerates the columns to which a rule, or default, is bound or the columns defined on the user-defined data type.

구문

object
.ListBoundColumns(
)
as
SQLObjectList

Parts

  • object
    Expression that evaluates to an object in the Applies To list.

Prototype (C/C++)

HRESULT ListBoundColumns(
LPSQLDMOCOLUMNLIST* ppList);

Returns

A SQLObjectList object that contains 0 or more Column objects.

주의

A SQL Server default rule, or user-defined data type, cannot be dropped when bound to or used by any other SQL Server object.

For the Default or Rule object you can use the ListBoundColumns method to enumerate columns bound, and then use the Name property of Column objects returned and the UnbindFromColumn method of the object to remove bindings.

A SQL Server default or rule can be bound to a user-defined data type. Use the ListBoundDatatypes and UnbindFromDatatype methods to remove bindings on a user-defined data type.

Use the Datatype property, and optionally the Length property, of the Column object to redefine a column on a new data type.

Applies To:

Default Object

UserDefinedDatatype Object

Rule Object

 

참고 항목

참조

Column Object

도움말 및 정보

SQL Server 2005 지원 받기