Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server
Azure SQL Database
Azure SQL Managed Instance
Removes an application role from the current database.
Transact-SQL syntax conventions
Syntax
DROP APPLICATION ROLE rolename
Arguments
rolename
Specifies the name of the application role to be dropped.
Remarks
If the application role owns any securables it cannot be dropped. Before dropping an application role that owns securables, you must first transfer ownership of the securables, or drop them.
Note
Schemas aren't equivalent to database users. Use System catalog views to identify any differences between database users and schemas.
Permissions
Requires ALTER ANY APPLICATION ROLE permission on the database.
Examples
Drop application role "weekly_ledger" from the database.
DROP APPLICATION ROLE weekly_ledger;
GO
See Also
Application Roles
CREATE APPLICATION ROLE (Transact-SQL)
ALTER APPLICATION ROLE (Transact-SQL)
EVENTDATA (Transact-SQL)