When you drop a managed table using SQL syntax DROP TABLE table_name how does it impact metadata, history, and data stored in the table?

When you drop a managed table using SQL syntax DROP TABLE table_name how does it impact metadata, history, and data stored in the table?
A . Drops table from meta store, drops metadata, history, and data in storage.
B . Drops table from meta store and data from storage but keeps metadata and history in storage
C . Drops table from meta store, meta data and history but keeps the data in storage
D . Drops table but keeps meta data, history and data in storage
E . Drops table and history but keeps meta data and data in storage

Answer: A

Explanation:

For a managed table, a drop command will drop everything from metastore and storage.

See the below image to understand the differences between dropping an external table.

Diagram

Description automatically generated

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments