alter function string class

Description

Alters a function-string class, specifying whether it should be a base class or a derived class.

Syntax

alter function string class function_class
   set parent to {parent_class | null}

Parameters

function_class

The name of an existing function-string class to be altered.

set parent to

Designates an existing class as a parent for the class you are altering; or, with the null keyword, designates that the class should be a base class.

parent_class

The name of an existing function-string class you designate as the parent class for a new derived class. rs_sqlserver_function_class may not be used as a parent class.

null

Specifies that the class should be a base class.

Examples

Example 1

Specifies that sqlserver2_function_class should become a derived class, inheriting function strings from the parent class rs_default_function_class:

alter function string class
 sqlserver2_function_class
 set parent to rs_default_function_class

Example 2

Specifies that the derived function-string class named rpc_xact should be a base class:

alter function string class rpc_xact
 set parent to null

Usage

Permissions

alter function string class requires "sa" permission.

See also

alter connection, create connection, create function, create function string, create function string class, drop function string class