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

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