Drops a function replication definition and its user-defined function.
drop function replication definition function_rep_def
The name of the function replication definition to drop.
Drops the function replication definition named titles_frep and its user-defined function and function string:
drop function replication definition titles_frep
Use drop function replication definition to remove a function replication definition.
Before you can drop a function replication definition, you must drop all subscriptions for it.
Execute drop function replication definition at the primary Replication Server for the function replication definition.
After you drop the stored procedure defined by this function replication definition, execute sp_setrepproc in the database, setting the procedure’s replicate status to 'false'. This stops the RepAgent from transferring log entries to the Replication Server.
Replication Server distributes information about the dropped function replication definition 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 replication definition requires “create object” permission.
alter function replication definition, check subscription, create function replication definition, create subscription, define subscription, drop subscription
