SALES: 1-800-867-1380

sp_delete_firewall_rule (Azure SQL Database)

Updated: November 21, 2014

This topic is OBSOLETE. You can find the most current version in the SQL 14 Transact-SQL Reference.

This topic is not maintained. For the current version, see sp_delete_ firewall_rule.

Removes server-level firewall settings from your Azure SQL Database server. This stored procedure is only available in the master database to the server-level principal login. The sp_delete_firewall_rule stored procedure is specific to Microsoft Azure SQL Database and is not supported in on-premise SQL Server.

Syntax Conventions (Azure SQL Database)

sp_delete_firewall_rule [@name =] ‘name’

The argument of the stored procedure is:


Name Datatype Description

[@name =] ‘name’


The name of the server-level firewall setting that will be removed.

Only the server-level principal login created by the provisioning process can delete server level firewall rules. The user must be connected to the master database to execute sp_delete_firewall_rule.

The following code removes the server-level firewall setting named ‘Example setting 1’.

-- Remove example server-level firewall setting
exec sp_delete_firewall_rule N'Example setting 1'

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
© 2015 Microsoft