| title | sp_delete_database_firewall_rule (Azure SQL Database) | ||||
|---|---|---|---|---|---|
| description | sp_delete_database_firewall_rule removes database-level firewall setting from your Azure SQL Database. | ||||
| author | VanMSFT | ||||
| ms.author | vanto | ||||
| ms.reviewer | randolphwest | ||||
| ms.date | 06/23/2025 | ||||
| ms.service | azure-sql-database | ||||
| ms.topic | reference | ||||
| f1_keywords |
|
||||
| helpviewer_keywords |
|
||||
| dev_langs |
|
||||
| monikerRange | =azuresqldb-current |
[!INCLUDE Azure SQL Database]
Removes database-level firewall setting from your [!INCLUDE ssazure-sqldb]. Database firewall rules can be configured and deleted for the master database, and for user databases on [!INCLUDE ssSDS_md].
sp_delete_database_firewall_rule [ @name = ] [ N ] 'name'
[ ; ]
The name of the database-level firewall setting to be removed. @name is nvarchar(128) with no default value. The Unicode prefix N is optional for [!INCLUDE ssSDS_md].
Only the server-level principal login created by the provisioning process, or a Microsoft Entra admin assigned as admin, can delete database-level firewall rules.
[!INCLUDE entra-id]
The following example removes the database-level firewall setting named Example DB Setting 1.
EXECUTE sp_delete_database_firewall_rule N'Example DB Setting 1';