DROP TABLE removes the specified table and frees up internal storage used by the data. Both the SQL table and the D3 file are removed.
It is not possible to restore data after dropping a table. DROP TABLE is not supported by transaction processing and cannot be undone.
DROP TABLE table_name
For a set of nested tables, if the parent table is specified in the DROP TABLE statement, all the nested tables are dropped as well.