sys.sp_check_join_filter

Description

Verifies a join filter between two tables to determine if the join filter clause is valid. This stored procedure also returns information about the supplied join filter, including if it can be used with precomputed partitions for the given table. This stored procedure is executed at the Publisher on the publication. For more information, see Parameterized Filters - Optimize for ## Syntax

sp_check_join_filter
[ @filtered_table = ]
N
'filtered_table'
, [ @join_table = ]
N
'join_table'
, [ @join_filterclause = ]
N
'join_filterclause'
[ ; ]