DROP LIST statement (Delete list)

Function

The DROP LIST statement deletes a list or all lists owned by the user.

Privileges

Creator of the list

The creator of a list can delete the created list.

Format

DROP {LIST list-name|ALL LIST}

Operands

Specifies the name of a list that is to be deleted.

Specifies that all the lists owned by the user are to be deleted.

Common rules

  1. The DROP LIST statement is not subject to the ROLLBACK statement.
  2. Although the DROP LIST statement can be executed dynamically, it cannot be executed by embedding it directly in a host program.
  3. The same user cannot manipulate a list by connecting to HiRDB concurrently in multiple sessions.

Note

Even if there are no lists to be deleted, executing DROP ALL LIST does not result in an error.

Examples

  1. Delete a dependent list (FAMILYT):

    DROP LIST FAMILYT

  2. Delete all lists owned by the user:

    DROP ALL LIST