FÖRSÄLJNING: 1-800-867-1389
Det här innehållet finns inte tillgängligt på ditt språk men här finns den engelska versionen,

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'

Var detta till hjälp?
(1500 tecken kvar)
Tack för dina kommentarer
© 2015 Microsoft