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

title	titleSuffix	description	author	ms.author	ms.reviewer	ms.date	ms.service	ms.topic	helpviewer_keywords	dev_langs	monikerRange
Firewall rules stored procedures	Azure SQL Database	Firewall rules stored procedures (Azure SQL Database)	VanMSFT	vanto	randolphwest	08/21/2024	azure-sql-database	reference	firewall rules stored procedures firewall_rules, setting firewall_rules, Azure SQL Database firewall systems, Azure SQL Database	TSQL	=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.