DROP END USER CONTEXT

Purpose

Use DROP END USER CONTEXT to drop an end-user context.

Prerequisites

You do not need additional privileges for dropping an end-user context in your own schema. To drop an end-user context in other schemas you must have the DROP ANY END USER CONTEXT system privilege.

Syntax

Description of the illustration drop_end_user_context.gif

Semantics

• IF EXISTS: If you specify IF EXISTS and the end-user context does not exist, no error is raised. If the end-user context exists, then it will be dropped.

  If you do not specify IF EXISTS, and the end-user context does not exist, an error is raised. If the end-user context exists, then it will be dropped.

• schema: schema name of the end-user context definition.

• name: name of the end-user context definition.

Example

The following SQL statement drops the end-user context attribute hcm:

DROP END USER CONTEXT hr.hcm;