DROP CONTACT¶

Removes the specified contact from the current schema.

See also:: CREATE CONTACT , ALTER CONTACT, SHOW CONTACTS

Syntax¶

DROP CONTACT <name>

Copy

Parameters¶

name

Specifies the identifier of the contact to drop.

If the identifier contains spaces or special characters, the entire string must be enclosed in double quotes. Identifiers enclosed in double quotes are also case-sensitive.

For more information, see Identifier requirements.

Access control requirements¶

You must have the OWNERSHIP privilege on a contact to drop it.

Examples¶

The following example drops the contact named mycontact:

DROP CONTACT mycontact;

Copy

+---------------------------------+
| status                          |
|---------------------------------|
| MYCONTACT successfully dropped. |
+---------------------------------+