Help Replication and Event Publishing

DROP CONTACT command

Use the DROP CONTACT command to drop an existing contact.

Syntax

Read syntax diagramSkip visual syntax diagram
>>-DROP CONTACT----contact-name1----+--------------------------------+-><
                                    '-SUBSTITUTE WITH--contact-name2-'   

Parameters

CONTACT contact-name1
Specifies the name of the contact. The contact must exist.
SUBSTITUTE WITH contact-name2
Specifies the name of a contact. The contact must exist. If the contact being deleted is referenced by any alert conditions, then the alert conditions will now reference the contact represented in this clause.

Usage notes

If you drop a contact that is the only one referred by an alert condition, this command returns an error. In this case, you must either delete the alert condition before you drop the contact, or use the SUBSTITUTE WITH clause.

Example

To drop a contact REPLADMIN:
DROP CONTACT REPLADMIN


Send your feedback | Information roadmap | Replication group on My developerWorks

Update icon Last updated: 2011-10-21