drop function string

Drops a function string for a function-string class.

Syntax

drop function string
 [replication_definition.]function[;function_string]
 for function_class

Parameters

Examples

Usage

  • To replace an existing function string with a new one, use either alter function string or create function with overwrite.

    Warning!  If a transaction occurs between the time a function string is dropped and the time it is re-created, Replication Server detects the function string as missing and fails the transaction.
  • Dropping a function drops corresponding function strings from all function-string classes.

  • Dropping a customized function string from a derived function-string class causes that class to inherit the function-string from its parent class.

  • Dropping a customized function string from rs_sqlserver_function_class causes Replication Server to delete the customized and default function string. To revert the customized function string to the default function string for a function in the rs_sqlserver_function_class, use alter function string and omit the output clause.

  • Replication Server distributes information about the dropped function string to qualifying sites through the replication system. The changes do not appear immediately at all such sites because of normal replication system lag time.

Permissions

drop function string requires “create object” permission.

Related reference
alter function string
create function
create function string
create function string class
drop function