Specifies the type of object to drop, which can be one of the following keywords:

table

view

index

The following object types can also be dropped. These drop statements are described under separate entries in this chapter:

dbevent (see Drop Dbevent Statement)

group (see Drop Group Statement)

integrity (see Drop Integrity Statement)

link (applies to Ingres Star only—see the Ingres Star User Guide)

procedure

role (see Drop Role Statement)

rule (see Drop Rule Statement)

Specifies the name of a table, view, index, or other valid object.