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.
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