DROP TABLE Statements
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