drop-application-role-transact-sql.md

title	DROP APPLICATION ROLE (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/15/2017
ms.prod	sql
ms.prod_service	database-engine, sql-database
ms.component	t-sql|statements
ms.reviewer
ms.suite	sql
ms.technology	t-sql
ms.tgt_pltfrm
ms.topic	language-reference
f1_keywords	DROP_APPLICATION_ROLE_TSQL DROP APPLICATION ROLE
dev_langs	TSQL
helpviewer_keywords	dropping application roles deleting application roles removing application roles application roles [SQL Server], removing DROP APPLICATION ROLE statement
ms.assetid	44121ee7-ef40-405d-b03b-f8ddb4e3c559
caps.latest.revision	24
author	edmacauley
ms.author	edmaca
manager	craigg

DROP APPLICATION ROLE (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-asdb-xxxx-xxx-md]

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.

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)