Firewall rules stored procedures (Azure SQL Database)

Applies to: Azure SQL Database Azure Synapse Analytics

This section contains the following stored procedures that set or delete firewall rules. Transact-SQL firewall rules can be used with SQL Database and Azure Synapse Analytics. 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 SQL Server, use Windows firewall rules. For more information, see Configure Windows Firewall for Database Engine access.