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.
The argument of the stored procedure is:
[@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'