Dropping a database object removes the specified object from the database.
- In the Administration perspective, right-click a database or user in the Navigator tree and select the applicable Show command for the kind of object you want to drop. A list of those types of objects in the selected database or user appears in the Object List Viewer.
- In the Object List Viewer, right-click one or more objects that you want to drop and select Drop.
- [Cloudera Only] In the Drop Confirmation message for Cloudera Hadoop connections using the Impala JDBC driver, select Refresh Impala Metadata to refresh the metadata after the drop.
- In the Drop Confirmation message, click Yes to confirm the drop operation. The selected object or group of objects are dropped from the connected database.