9.7.4 DROP

Purpose

The DROP command removes the named objects from the database server or resets a database server.

Syntax

DROP object_type [object_name [, object_name]...] [options]

Usage Notes

• object_type can be one of the following:

  • ALERTHISTORY

  • DBSERVER

  • ROLE

  • THRESHOLD

  • USER

• object_name is the name of a database server disk, role, threshold, or user.

• When multiple objects are the target of a DROP command, there is the possibility of partial success. If an error occurs, then the command is interrupted, and the remaining objects are not dropped.

• DROP ALERTHISTORY
  
• DROP DBSERVER
  
• DROP ROLE
  
• DROP THRESHOLD
  
• DROP USER