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 drop_end_user_context.eps follows
Description of the illustration drop_end_user_context.eps

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;