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 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 Windows firewall rules. For more information, see Configure a Windows Firewall for Database Engine Access.