Firewall Rules Stored Procedures (Azure SQL Database)

APPLIES TO: noSQL Server yesAzure SQL Database yesAzure SQL Data Warehouse noParallel Data Warehouse

This section contains the following stored procedures that set or delete firewall rules. Transact-SQL firewall rules can be used with SQL Database and SQL Data Warehouse. For more information, see Configure Azure SQL Database firewall rules - overview.

sp_set_firewall_rule (Azure SQL Database) sp_delete_firewall_rule (Azure SQL Database)
sp_set_database_firewall_rule (Azure SQL Database) sp_delete_database_firewall_rule (Azure SQL Database)

For SQL Server, use Window firewall rules. For more information, see Configure a Windows Firewall for Database Engine Access.