Remove a File

Description

The DROP TABLE statement is also used to delete a file.

Here is the syntax:

DROP TABLE files.file_name;

On execution, we get:

Query successfully completed

Please note that the uploaded files are tables as well. So to remove an uploaded file, use this DROP TABLE statement.