This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
The DistributionPublishers collection contains DistributionPublisher objects that expose the properties of Publishers using the referenced Distributor.
With the DistributionPublishers collection, you can:
Add a Publisher to a Distributor.
Generate a Transact-SQL command batch to script Publisher configuration for all Publishers using a Distributor.
Remove a Publisher from a Distributor.
To remove a Publisher from a Distributor
Get a DistributionPublisher object from the DistributionPublishers collection of a connected Distributor object.
Use the Remove method.