Removes an application role from the current database.
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Use DROP APPLICATION ROLE instead.
sp_dropapprole can only be used to remove application roles. If a role owns any securables, the role cannot be dropped. Before dropping an application role that owns securables, you must first transfer ownership of the securables, or drop them.
sp_dropapprole cannot be executed within a user-defined transaction.
The following example removes the SalesApp application role from the current database.
EXEC sp_dropapprole 'SalesApp'