sp_schemafilter (Transact-SQL)
Applies to: SQL Server
Modifies and displays information on the schema that is excluded when listing Oracle tables eligible for publishing.
Transact-SQL syntax conventions
Syntax
sp_schemafilter [ @publisher = ] 'publisher'
[ , [ @schema = ] 'schema' ]
[ , [ @operation = ] 'operation' ]
Arguments
[ @publisher = ] 'publisher'
Is the name of the non- Microsoft SQL Server Publisher. publisher is sysname, with no default.
[ @schema = ] 'schema'
Is the name of the schema. schema is sysname, with a default value of NULL.
[ @operation = ] 'operation'
Is the action to be taken on this schema. operation is nvarchar(4), and can be one of the following values.
Value | Description |
---|---|
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 | Description |
---|---|---|
schemaname | sysname | Is the name of the schema not eligible for publication. |
Return Code Values
0 (success) or 1 (failure)
Remarks
sp_schemafilter should only be used for heterogeneous publishers.
Permissions
Only members of the sysadmin fixed server role at the Distributor can execute sp_schemafilter.
See Also
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for