For Amazon S3 data sources, the DROP TABLE command logically removes a table from the source and physically removes all files associated with the table. After the table is dropped, it is permanently deleted and cannot be restored.
For Amazon Glue data sources, the DROP TABLE command removes a table from the catalog. The datafiles are not deleted from the warehouse.Syntax
DROP TABLE [ IF EXISTS ] <table_name>
[ IF EXISTS ]
When included, the command will succeed regardless of whether the table existed. If this clause is not specified, the command will fail if the table to be dropped does not exist.
The name of the table that you want to drop.