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

description	sp_delete_database_firewall_rule (Azure SQL Database)
title	sp_delete_database_firewall_rule (Azure SQL Database) | Microsoft Docs
ms.custom
ms.date	08/04/2017
ms.service	sql-database
ms.reviewer
ms.topic	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
author	VanMSFT
ms.author	vanto
monikerRange	= azuresqldb-current

sp_delete_database_firewall_rule (Azure SQL Database)

[!INCLUDEAzure SQL Database]

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 =] [N]'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)