Summary -

In this topic, we described about the DROP Statement with detailed example.

DROP statement used to DROP the DB2 objects created . DROP will also drop the data in it along with Object dropping. To DROP the objects SYSADM or SYSCTRL authority along with DBADM authority on DATABASE.

Syntax -

DROP object-name.

The DROP can be performed on the below list of Db2 objects.

DROP ALIAS
DROP DATABASE
DROP FUNCTION
DROP INDEX
DROP PACKAGE
DROP PROCEDURE 
DROP ROLE
DROP SEQUENCE
DROP STOGROUP
DROP SYNONYM
DROP TABLE
DROP TABLESPACE
DROP TRIGGER
DROP TYPE
DROP VIEW