sp_schemafilter (Transact-SQL)sp_schemafilter (Transact-SQL)

本主題適用於:是SQL Server (從 2008 開始)否Azure SQL Database否Azure SQL 資料倉儲 否平行處理資料倉儲 THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

修改和顯示當列出適合發行的 Oracle 資料表時所排除之結構描述的相關資訊。Modifies and displays information on the schema that is excluded when listing Oracle tables eligible for publishing.

主題連結圖示 Transact-SQL 語法慣例Topic link icon Transact-SQL Syntax Conventions


sp_schemafilter [ @publisher = ] 'publisher'   
   [ , [ @schema = ] 'schema' ]   
   [ , [ @operation = ] 'operation' ]   


[ @publisher =] '發行者'[@publisher = ] 'publisher'
名稱非 MicrosoftMicrosoft SQL ServerSQL Server發行者。Is the name of the non- MicrosoftMicrosoft SQL ServerSQL Server Publisher. 發行者sysname,沒有預設值。publisher is sysname, with no default.

[ @schema =] '結構描述'[@schema = ] 'schema'
這是結構描述的名稱。Is the name of the schema. 結構描述sysname,預設值是 NULL。schema is sysname, with a default value of NULL.

[ @operation =] '作業'[@operation = ] 'operation'
這是在此結構描述上所要採取的動作。Is the action to be taken on this schema. 作業nvarchar (4),而且可以是下列值之一。operation is nvarchar(4), and can be one of the following values.

Value DescriptionDescription
新增add 將指定的結構描述加入不適合發行的結構描述清單中。Adds the specified schema to the list of schema that are not eligible for publication.
卸除drop 從不適合發行的結構描述清單中,卸除指定的結構描述。Drops the specified schema from the list of schema that are not eligible for publication.
說明help 傳回不適合發行的結構描述清單。Returns the list of schema that are not eligible for publication.

結果集Result Sets

資料行名稱Column name 資料類型Data type DescriptionDescription
schemanameschemaname sysnamesysname 這是不適合發行的結構描述名稱。Is the name of the schema not eligible for publication.

傳回碼值Return Code Values

0 (成功) 或1 (失敗)0 (success) or 1 (failure)


sp_schemafilter只應用於異質性發行者。sp_schemafilter should only be used for heterogeneous publishers.


只有成員sysadmin散發者端的固定的伺服器角色可以執行sp_schemafilterOnly members of the sysadmin fixed server role at the Distributor can execute sp_schemafilter.

請參閱<See Also

複寫預存程序 (Transact-SQL)Replication Stored Procedures (Transact-SQL)