UserDefinedDatatypes Collection

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

The UserDefinedDatatypes collection contains UserDefinedDatatype objects that reference a Microsoft SQL Server data integrity mechanism called a user-defined data type.

Properties

Count Property

Methods

Add Method	Refresh Method
Item Method	Remove Method (Collections)
ItemByID Method

주의

With the UserDefinedDatatypes collection, you can:

• Create a new user-defined data type.

• Remove a user-defined data type.

For more information about creating and removing user-defined data types by using the UserDefinedDatatype object and UserDefinedDatatypes collection, see UserDefinedDatatype Object.

When using the Item or Remove method, the UserDefinedDatatypes collection supports member identification using either name or ordinal reference syntax. For example:

Set oUDT = oDatabase.UserDefinedDatatypes("EmployeeID")

Or:

Set oUDT = oDatabase.UserDefinedDatatypes(2)

Additionally, when using name-based item selection, the Item method allows owner name qualification of the targeted SQL Server user-defined data type. For example:

Set oUDT = oDatabase.UserDefinedDatatypes("EmployeeID", "dbo")

When using the Remove method, the UserDefinedDatatypes collection does not support qualification of targeted object by owner name. It is suggested that you use the Item method to extract the target, and then use the Remove method of the UserDefinedDatatype object to drop a user-defined data type.

[!참고]

Creating or removing SQL Server data integrity constraints implemented as user-defined data types by using the UserDefinedDatatypes collection requires appropriate privilege. The SQL Server login used for SQLServer object connection must be a member of the fixed role db_ddladmin or a role with greater privilege.