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