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