Drops a function string for a function-string class.
drop function string [replication_definition.]function[;function_string | all] for function_class
The name of the table or function replication definition the function operates on.
The name of the function the function string was created for.
The name of the function string to drop. The default function string name is the same as the function name.
Causes Replication Server to drop all function strings for a function. Although only the rs_select, rs_select_with_lock, rs_datarow_for_writetext, rs_get_textptr, rs_textptr_init, and rs_writetext functions can have multiple function strings, this option can be used as shorthand for the function_string name.
The name of the function-string class from which the function string will be dropped.
Drops the function strings for the rs_insert function for the publishers_rep replication definition in the derived class sqlserver_derived_class. The rs_insert function string will now be inherited from the parent class:
drop function string publishers_rep.rs_insert for sqlserver_derived_class
Drops the function string for the upd_publishers user-defined function for the publishers_rep replication definition in the sqlserver2_function_class function-string class:
drop function string publishers_rep.upd_publishers for sqlserver2_function_class
Drops all function strings for the rs_select_with_lock function for the publishers_rep replication definition in the class sqlserver2_func_class:
drop function string publishers_rep.rs_select_with_lock;all for sqlserver2_func_class
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.
drop function string requires “create object” permission.
alter function string, create function, create function string, create function string class, drop function
