DROP APPLICATION ROLE

Remove an application role from the current database.

Syntax
      DROP APPLICATION ROLE rolename

Requires ALTER ANY APPLICATION ROLE permission on the database.

Example

DROP APPLICATION ROLE Vincentio;
GO

#Now the king told the boogie men, You have to let that raga drop
The oil down the desert way, Has been shakin' to the top# - The Clash (Rock the Casbah)

Related commands:

CREATE APPLICATION ROLE
ALTER APPLICATION ROLE

Equivalent Oracle command:

ALTER SESSION SET CURRENT SCHEMA