Replication filters qualify rows for a replication path based on the search conditions that you have defined in the filter clause.
Use create replication filter to create a replication filter on a table at the primary Adaptive Server database. The filter defines the conditions to apply to a log record for any table that you specify in the primary database. The Adaptive Server RepAgent uses the replication filter at the primary database to determine if the data in a log record meets the criteria to send the data to the destination for any of the paths to which the filter is bound.After you bind a filter to a replication path, RepAgent only replicates the data that satisfies the filter conditions through the path.
Remove filters with drop replication filter. RepAgent automatically drops filters that you create on a table if you drop the table that has the filters.
You must drop and recreate a filter if you want to alter any conditions in the filter.
Use sp_reptostandby to enable replication of DDL commands such as create replication filter and drop replication filter.
See create replication filter, drop replication filter, and sp_reptostandby in the Replication Server Reference Manual.
Display the filter conditions defined in any replication filter with the sp_helptext filtername procedure at the primary Adaptive Server database. See sp_helptext in the Adaptive Server Enterprise Reference Manual: Procedures > System Procedures