drop-application-role-transact-sql.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	f1_keywords	helpviewer_keywords	dev_langs
DROP APPLICATION ROLE (Transact-SQL)	DROP APPLICATION ROLE (Transact-SQL)	VanMSFT	vanto	03/15/2017	sql	t-sql	reference	DROP_APPLICATION_ROLE_TSQL DROP APPLICATION ROLE	dropping application roles deleting application roles removing application roles application roles [SQL Server], removing DROP APPLICATION ROLE statement	TSQL

DROP APPLICATION ROLE (Transact-SQL)

[!INCLUDE SQL Server Azure SQL Database Azure SQL Managed Instance]

Removes an application role from the current database.

:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: 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.

Caution

[!INCLUDEssCautionUserSchema]

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)