Delete a subscription object from the database.
Syntax
sp_DropSubscription(SubscriptionName,CHARACTER,200 )
Parameters
SubscriptionName (I) |
Name of the subscription object to delete. |
Special Return Codes
AE_INVALID_OBJECT_NAME |
The subscription specified by SubscriptionName cannot be located in the data dictionary. |
Remarks
sp_DropSubscription removes an existing subscription from the database.
Example
EXECUTE PROCEDURE sp_DropSubscription( 'mysub' )
See Also