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" monikerRange: "= azuresqldb-current || = sqlallproducts-allversions"
[!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].
sp_delete_database_firewall_rule [@name =] [N]'name'
[ ; ]
[@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].
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.
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';
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)