External tables in Hive refer to the data that is at an existing location outside the warehouse directory
Hive deletes the metadata information of a table and does not change the table data present in HDFS
Also known as the internal table, these types of tables manage the data and move it into its warehouse directory by default
If one drops a managed table, the metadata information along with the table data is deleted from the Hive warehouse directory