DROP LINK
Remove a connection link on S3, Azure, GCS, HDFS, or Kafka for a permitted user.
Syntax
DROP LINK [db_name.]connection_name
Remarks
db_name
is the name of the SingleStoreDB database. It is an optional parameter. If not specified, the connection link is dropped from the current (context) database.This command causes implicit commits. See COMMIT for more information.
To drop a connection link, you need the
DROP LINK
permission. Contact your administrator to grant this permission.See the Permission Matrix for the required permission.
Example
SHOW LINKS ON Orderdb; **** +-------------------------+--------+-----------------------------+ | Link | Type | Description | +-------------------------+--------+-----------------------------+ | product_S3 | S3 | Product list | | brand_S3 | S3 | Brand list | +-------------------------+--------+-----------------------------+
DROP LINK Orderdb.brand_S3; SHOW LINKS ON Orderdb; **** +-------------------------+--------+-----------------------------+ | Link | Type | Description | +-------------------------+--------+-----------------------------+ | product_S3 | S3 | Product list | +-------------------------+--------+-----------------------------+