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