Use DROP TABLE statements to delete a table and all the data it contains from Avro.

DROP TABLE Syntax

The DROP TABLE statement accepts the name of the table to delete, as shown in the following example:

DROP TABLE [ IF EXISTS ] <table_name> 

The following query deletes all MyCustomers data from the server:

DROP TABLE IF EXISTS MyCustomers

Note: DROP TABLE is only supported for tables that correspond to local files in Avro. This functionality is not available for cloud-based data sources.