Skip to content
≡

Administrator

Developer

Tools

External Tools

DROP USER

DROP USER#

Syntax#

drop_user ::=#

drop_user_image169

Prerequisites#

Only the SYS user and users with the DROP USER system privilege can execute the DROP USER statement.

Description#

This statement is used to drop the specified user from the database.

user_name#

This is used to specify the name of the user to drop.

CASCADE#

This is used to specify that not only the database user but also all objects in the user's schema will be dropped. Additionally, any referential integrity constraints that refer to primary and unique keys in tables belonging to the user's schema will also be dropped.

If there is an object in the user schema to be deleted and omit CASCADE, an error will be returend and the DROP USER statement will fail.

Examples#

<Query> Drop the user uare1.

iSQL> DROP USER uare1;
Drop success.

<Query> Drop the user uare4 and all of the user's objects.

iSQL> DROP USER uare4 CASCADE;
Drop success.