You can use the DROP CATALOG [IF EXISTS] external_catalog_name; statement to delete a catalog that is no longer in use.
When you delete a catalog, if you specify IF EXISTS, no error is returned even if the catalog does not exist. If you do not specify IF EXISTS, an error is returned.
Here is an example:
obclient> DROP CATALOG IF EXISTS test_odps_catalog;