DROP CONTACT¶

Removes the specified contact from the current schema.

See also:

CREATE CONTACT , ALTER CONTACT, SHOW CONTACTS

语法

DROP CONTACT <name>

参数

name

指定要删除的联系人的标识符。

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.

访问控制要求

您必须对联系人拥有 OWNERSHIP 权限才能删除该联系人。

示例

The following example drops the contact named mycontact:

DROP CONTACT mycontact;

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