Example 1: Drop your table named MY_IN_TRAY. Do not allow the drop if any views or indexes are created over this table.
DROP TABLE MY_IN_TRAY RESTRICT
Example 2: Drop your view named MA_PROJ.
DROP VIEW MA_PROJ
Example 3: Drop the package named PERS.PACKA.
DROP PACKAGE PERS.PACKA
Example 4: Drop the distinct type DOCUMENT, if it is not currently in use:
DROP DISTINCT TYPE DOCUMENT RESTRICT
Example 5: Assume that you are SMITH and that ATOMIC_WEIGHT is the only function with that name in schema CHEM. Drop ATOMIC_WEIGHT.
DROP FUNCTION CHEM.ATOMIC_WEIGHT RESTRICT
Example 6: Drop CENTER, using the function signature to identify the function instance to be dropped.
DROP FUNCTION CENTER (INTEGER, FLOAT) RESTRICT
Example 7: Assume that you are SMITH and that you created another function named CENTER, which you gave the specific name FOCUS97, in schema JOHNSON. Drop CENTER, using the specific name to identify the function instance to be dropped.
DROP SPECIFIC FUNCTION JOHNSON.FOCUS97
Example 8: Assume that you are SMITH and that stored procedure OSMOSIS is in schema BIOLOGY. Drop OSMOSIS.
DROP PROCEDURE BIOLOGY.OSMOSIS
Example 9: Assume that you are SMITH and that trigger BONUS is in your schema. Drop BONUS.
DROP TRIGGER BONUS
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.