DROP HIERARCHY
[ schema. ] hierarchy_name;