|Oracle8i SQL Reference
Release 3 (8.1.7)
Part Number A85397-01
DROP SEQUENCE to UPDATE, 9 of 27
USER statement to remove a database user and optionally remove the user's objects.
You must have the
USER system privilege.
Specify the user to be dropped. Oracle does not drop users whose schemas contain objects unless you specify
CASCADE, or unless you first explicitly drop the user's objects.
CASCADE to drop all objects in the user's schema before dropping the user. You must specify this clause to drop a user whose schema contains any objects.
CASCADE, the materialized views can no longer be refreshed.
If user Bradley's schema contains no objects, you can drop
bradley by issuing the statement:
If Bradley's schema contains objects, you must use the
CASCADE clause to drop
bradley and the objects: