You have a managed table, so when you do 'drop table <table_name>' it will remove the underlining data + metadata. If this was an external table, then a "drop table <table_name>" will not remove the data associated to the table. I just thought about sharing this, to show the difference between managed and unmanaged (external) tables