DB2 DROP Statement

DB2 ALTER Statement DB2 DDL Primary key

Advertisements


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

DB2 ALTER Statement DB2 DDL Primary key

Advertisements