Syntax
The DROP PROFILE statement has the following format:
[EXEC SQL] DROP PROFILE profile_name [RESTRICT | CASCADE]
RESTRICT
(Default) Specifies that if any users have this profile the statement is rejected.
CASCADE
Specifies that any users with this profile have their profile reset to the default profile.