Drop Function Strings Examples

Learn from the examples showing how to drop function strings.

Drop Function String for the Replication Definition

The following command drops the rs_insert function string for the publishers_rep replication definition in the class sqlserver2_func_class:

drop function string
publishers_rep.rs_insert
for sqlserver2_func_class

Drop Instance of a Function String for the Replication Definition

The following command drops the pub_id instance of a function string for the rs_select function for the publishers_rep replication definition in the class derived_class. Drop function strings for the rs_select_with_lock function in a similar way.

drop function string
publishers_rep.rs_select;pub_id
for derived_class

Drop Function String from Function-string Class

The following command drops the rs_begin function string from the gateway_func_class function-string class:

drop function string rs_begin
for gateway_func_class

Drop Function String for a Target Database

The following command drops the function string for the target stored procedure from the database NY_DS.rdb1:

drop function string upd_bits.upd_bits
for database NY_DS.rdb1