# DROP statements

Use DROP statements to remove functions, indexes, procedures, roles, schemas, synonyms, tables, triggers, and views.

- DROP DERBY AGGREGATE statement
  The DROP DERBY AGGREGATE statement removes the specified user-defined aggregate (UDA).
- DROP FUNCTION statement
  The DROP FUNCTION statement removes the specified Java function.
- DROP INDEX statement
  The DROP INDEX statement removes the specified index.
- DROP PROCEDURE statement
  The DROP PROCEDURE statement removes the specified Java stored procedure.
- DROP ROLE statement
  The DROP ROLE statement removes the specified SQL role.
- DROP SCHEMA statement
  The DROP SCHEMA statement removes the specified schema.
- DROP SEQUENCE statement
  The DROP SEQUENCE statement removes the specified sequence generator.
- DROP SYNONYM statement
  The DROP SYNONYM statement removes the specified synonym from a table or view.
- DROP TABLE statement
  The DROP TABLE statement removes the specified table.
- DROP TRIGGER statement
  The DROP TRIGGER statement removes the specified trigger.
- DROP TYPE statement
  The DROP TYPE statement removes the specified user-defined type (UDT).
- DROP VIEW statement
  The DROP VIEW statement removes the specified view.

Parent topic: Statements