DROP RECIPIENT
适用于: Databricks SQL Databricks Runtime 10.4 LTS 及更高版本 仅 Unity Catalog
删除收件人。 如果系统中不存在该收件人,则会引发异常。 若要删除某个接收者,你必须是其所有者。
语法
DROP RECIPIENT [ IF EXISTS ] recipient_name
参数
IF EXISTS
如果已指定,则仅在收件人存在时才会引发异常。
-
系统中现有收件人的名称。 如果该名称不存在,则会引发异常。
示例
-- Create `other_corp` recipient
> CREATE RECIPIENT other_corp COMMENT 'OtherCorp.com';
-- Retrieve the activation link
> DESCRIBE RECIPIENT other_corp;
name created_at created_by comment activation_link active_token_id active_token_expiration_time rotated_token_id rotated_token_expiration_time
---------- ---------------------------- -------------------------- ------------- ----------------- ------------------------------------ ---------------------------- ---------------- -----------------------------
other_corp 2022-01-01T00:00:00.000+0000 alwaysworks@databricks.com OtherCorp.com https://send/this 0160c81f-5262-40bb-9b03-3ee12e6d98d7 9999-12-31T23:59:59.999+0000 NULL NULL
-- Drop the recipient
> DROP RECIPIENT other_corp;
-- Drop the recipient using IF EXISTS.
> DROP RECIPIENT IF EXISTS other_corp;