Convert a managed table to external

You can easily convert a managed table to external using the ALTER TABLE statement.

The following pseudo-code changes a table to external. The data and metadata is dropped when the table is dropped.

ALTER TABLE ... SET TBLPROPERTIES('EXTERNAL'='TRUE','external.table.purge'='true')