The following statements drop the following objects from the database:
DROP TABLE person removes the table 'person'.
DROP VIEW v1 removes the view 'v1'.
DROP SNAPSHOT snap1 removes the snapshot table 'snap1'.
DROP SNAPSHOT customer removes the snapshot log from the table customer.
LOG ON
DROP SYNONYM negative removes the additional name 'negative'.
DROP INDEX customer.name removes the index 'customer.name'.
DROP DOMAIN name removes the domain 'name'.
DROP TRIGGER account_statistics removes the trigger account_statistics.
DROP TABLE removes a table definition together with its contents and depending objects such as views, synonyms or indexes. So BE CAREFUL! The statement can only be executed by the owner of a table.
DROP VIEW removes the user window on table contents. The contents themselves remain untouched.
DROP SNAPSHOT removes the copy (snapshot) of the contents of a table.
DROP SNAPSHOT removes the modification log (snapshot log) of a table.
LOG ON
DROP SYNONYM removes the additional name of a table. The original definition and the contents of the table are kept.
DROP INDEX removes the index file which was created in order to increase the system performance. This is the only effect.
DROP DOMAIN removes the definition of a domain. Table definitions which used these domains are kept. Of course, CREATE TABLE statements containing dropped domain definitions can no longer be issued.
DROP TRIGGER removes a trigger. The procedure where these processing steps are defined is kept.