SALES: 1-800-867-1380

sp_delete_database_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_database_firewall_rule.

Removes database-level firewall setting from your Microsoft Azure SQL Database instance. This stored procedure is available in the master database and user databases. The sp_delete_database_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_database_firewall_rule [@name =] ‘name’

The argument of the stored procedure is:


Name Datatype Description

[@name =] ‘name’


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

Only the server-level principal login created by the provisioning process can delete database level firewall rules.

The following code removes the database-level firewall setting named ‘Example DB Setting 1’.

-- Remove database-level firewall setting
exec sp_delete_database_firewall_rule N'Example DB Setting 1'

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