Examples

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