drop-application-role-transact-sql.md

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

Note

[!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)