次の方法で共有


UserDefinedFunction Object

この機能は、将来のバージョンの Microsoft SQL Server では削除される予定です。 新しい開発作業では、この機能の使用を避け、現在この機能を使用しているアプリケーションは修正するようにしてください。

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

現在のオブジェクトを表す SQL-DMO オブジェクト モデル

説明

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.