sp_delete_database_firewall_rule (Azure SQL Database)

THIS TOPIC APPLIES TO: noSQL Server yesAzure SQL DatabaseyesAzure SQL Data Warehouse noParallel Data Warehouse

Removes database-level firewall setting from your Azure SQL Database or SQL Data Warehouse. Database firewall rules can be configured and deleted for the master database, and for user databases on SQL Database.


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 required for SQL Data Warehouse but optional for SQL Database.


Only the server-level principal login created by the provisioning process 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';  

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)