sp-delete-database-firewall-rule-azure-sql-database.md

title	sp_delete_database_firewall_rule (Azure SQL Database) | Microsoft Docs
ms.custom
ms.date	08/04/2017
ms.prod
ms.prod_service	sql-database
ms.reviewer
ms.service	sql-database
ms.component	system-stored-procedures
ms.suite	sql
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	language-reference
f1_keywords	sp_delete_database_firewall_rule sp_delete_database_firewall_rule_TSQL sys.sp_delete_database_firewall_rule sys.sp_delete_database_firewall_rule_TSQL
dev_langs	TSQL
helpviewer_keywords	sp_delete_database_firewall_rule procedure
ms.assetid	ed295312-e586-4fc2-9e80-806b490ee7bd
caps.latest.revision	13
author	edmacauley
ms.author	edmaca
manager	craigg
ms.workload	Inactive

sp_delete_database_firewall_rule (Azure SQL Database)

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

Removes database-level firewall setting from your [!INCLUDEssSDSfull]. Database firewall rules can be configured and deleted for the master database, and for user databases on [!INCLUDEssSDS_md].

Syntax

  
sp_delete_database_firewall_rule [@name =] [N]'name'
[ ; ]  

Arguments

[@name =] 'name'
The name of the database-level firewall setting that will be removed. name is nvarchar(128) with no default value. The Unicode identifier N is optional for [!INCLUDEssSDS_md].

Permissions

Only the server-level principal login created by the provisioning process or an Azure Active Directory principal assigned as admin can delete database-level firewall rules.

Example

The following example removes the database-level firewall setting named Example DB Setting 1.

-- Remove database-level firewall setting  
EXECUTE sp_delete_database_firewall_rule N'Example DB Setting 1';  
  

See Also

Azure SQL Database Firewall
How to: Configure Firewall Settings (Azure SQL Database)
sp_set_firewall_rule (Azure SQL Database)
sp_set_database_firewall_rule (Azure SQL Database)
sys.database_firewall_rules (Azure SQL Database)