Show TOC

drop function string classLocate this document in the navigation structure

Drops a function-string class.

Syntax
drop function string class <function_class>
Parameters
function_class

The name of the function-string class to drop.

Examples
Example 1

Drops the derived function-string class <sqlserver_derived_class> and all of its customized function strings:

drop function string class
 sqlserver_derived_class
Example 2

Drops the function-string class <sqlserver2_function_class> and its function strings:

drop function string class
 sqlserver2_function_class
Usage
  • Use drop function string class to remove a function-string class. function-string classes group all function strings for a database.

  • Dropping a function-string class also drops all of the associated function strings and removes all references to the class.

  • A function-string class that is still in use on a database connection cannot be dropped.

  • You cannot drop any of the three system-provided classes, <rs_sqlserver_function_class>, <rs_default_function_class>, or <rs_db2_function_class>.

  • You cannot drop any function-string class that is a parent class for a derived class.

Permissions

drop function string class requires “sa” permission.