firewall-rules-stored-procedures-azure-sql-database.md

title	Firewall Rules Stored Procedures
titleSuffix	Azure SQL Database
description	Firewall rules stored procedures (Azure SQL Database)
author	VanMSFT
ms.author	vanto
ms.reviewer	randolphwest
ms.date	06/23/2025
ms.service	azure-sql-database
ms.topic	reference
helpviewer_keywords	firewall rules stored procedures firewall_rules, setting firewall_rules, Azure SQL Database firewall systems, Azure SQL Database
dev_langs	TSQL
monikerRange	=azuresqldb-current || =azure-sqldw-latest

Firewall rules stored procedures (Azure SQL Database)

[!INCLUDE asdb-asa]

This section contains the following stored procedures that set or delete firewall rules. [!INCLUDE tsql_md] firewall rules can be used with [!INCLUDE ssSDS_md] and [!INCLUDE ssazuresynapse-md]. For more information, see Azure SQL Database and Azure Synapse IP firewall rules.

• 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 [!INCLUDE ssNoVersion_md], use Windows firewall rules. For more information, see Configure Windows Firewall for Database Engine access.