Show TOC

drop replication filterLocate this document in the navigation structure

Removes a replication filter that is not bound to a replication path.

Syntax
drop replication filter <filter_name>
Parameters
<filter_name >
The name of the filter object
Examples
Example 1

Drop a filter named advance_vs_revenue :

drop replication filter advance_vs_filter
Usage
  • You must unbind the filter from all replication paths before you can drop the filter. RepAgent does not allow you to drop a filter that is bound to a replication path.
  • Adaptive Server drops the filter if you drop the table associated with the filter. However, if you drop the filter, there is no effect on the associated table.
  • You cannot alter a table with the Adaptive Server alter table command if the table has a column with a filter. If you attempt to alter the table, an error message displays, advising you to drop and recreate replication filters.
  • If you drop a filter, Adaptive Server drops all rows in the sysattributes table that have IDs that correspond to the filter.
  • If there is any attempt to use alter table to change a table with associated filters, Adaptive Server prevents alter table for the table from executing and displays an error message advising you to drop and recreate the filters.
Permissions

drop replication filter requires “create object” permission.