{ “title”: “DROP FILE”, “language”: “en” }

Description

This statement is used to delete an uploaded file.

grammar:

DROP FILE "<file_name>" [ { FROM | IN } <database>] PROPERTIES ("<key>"="<value>" [ , ... ])

Required Parameters

1. <file_name>

Custom file name.

2. <key>

File attribute key.

  • catalog: Required. Classification category of the file.

3. <value>

File attribute value.

Optional Parameters

1. <database>

Specifies the database to which the file belongs. Uses the current session's database if not specified.

Access Control Requirements

The user executing this SQL command must possess the following minimum privileges:

PrivilegeObjectNotes
ADMIN_PRIVUser / RoleThe user or role must hold the ADMIN_PRIV privilege to execute this operation

Example

  • Delete the file ca.pem

    DROP FILE "ca.pem" properties("catalog" = "kafka");

  • Delete file client.key categorized under my_catalog

    DROP FILE "client.key"
IN my_database

  • Delete file client_1.key categorized under my_catalog

    DROP FILE "client_1.key"
FROM my_database