UserDefinedFunction Object

  • 아티클

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

The UserDefinedFunction object exposes the attributes of a single user-defined function.

현재 개체를 보여 주는 SQL-DMO 개체 모델

Properties

AnsiNullsStatus Property

Name Property

CreateDate Property

Owner Property (Database, UserDefinedFunction)

Encrypted Property

QuotedIdentifierStatus Property

ID Property

SystemObject Property

IsDeleted Property

Text Property

IsDeterministic Property

Type Property (UserDefinedFunction)

IsSchemaBound Property

 

Methods

Alter Method

Grant Method (StoredProcedure, UserDefinedFunction)

Deny Method (UserDefinedFunction)

ListPermissions Method

EnumDependencies Method

ListUserPermissions Method

EnumOutputs Method

Remove Method (Objects)

EnumParameters Method

Revoke Method (UserDefinedFunction)

주의

With the UserDefinedFunction object, you can:

  • Create a Microsoft SQL Server user-defined function.
  • Change the definition of an existing SQL Server user-defined function.
  • Control access rights to an existing SQL Server user-defined function.
  • Delete an existing SQL Server user-defined function.
  • Generate a Transact-SQL script to re-create a SQL Server user-defined function.

The Name property of a UserDefinedFunction object uses the SQL Server sysname data type. The value of the Name property must be unique (named by owner) within a SQL Server database.

To create a SQL Server user-defined function

  1. Create a UserDefinedFunction object.

  2. Set the Name property.

  3. Set the Text property to contain the user-defined function.

  4. Set optional property values.

  5. Add the UserDefinedFunction object to the UserDefinedFunctions collection of a connected Database object.

After a user-defined function is created, you cannot reset the Name property. To change the name of a user-defined function, you must call the Remove method to drop and then re-create the object.

[!참고] The UserDefinedFunction object is compatible only with SQL Server 2000 and later.