Export (0) Print
Expand All

sp_delete_database_firewall_rule (Azure SQL Database)

SQL Server 2014

Removes database-level firewall setting from your instance. This stored procedure is available in the master database and user databases.

Applies to: .

sp_delete_database_firewall_rule [@name =] 'name'

[@name =] 'name'

The name of the database-level firewall setting that will be removed. name is nvarchar(128) with no default value.

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';

Community Additions

ADD
Show:
© 2014 Microsoft