Skip to content

Latest commit

 

History

History
57 lines (47 loc) · 3.68 KB

sys-firewall-rules-azure-sql-database.md

File metadata and controls

57 lines (47 loc) · 3.68 KB
title description author ms.author ms.reviewer ms.date ms.service ms.subservice ms.topic f1_keywords helpviewer_keywords dev_langs monikerRange
sys.firewall_rules (Azure SQL Database)
Returns information about the server-level firewall settings associated with your Azure SQL Database.
rwestMSFT
randolphwest
randolphwest
09/09/2022
sql
system-objects
reference
sys.firewall_rules
firewall_rules
sys.firewall_rules_TSQL
firewall_rules_TSQL
firewall_rules
sys.firewall_rules
TSQL
=azuresqldb-current

sys.firewall_rules (Azure SQL Database)

[!INCLUDEAzure SQL Database Azure SQL Managed Instance]

Returns information about the server-level firewall settings associated with your [!INCLUDE ssazure-sqldb].

The sys.firewall_rules view contains the following columns:

Column name Data type Description
id int The identifier of the server-level firewall setting.
name nvarchar(128) The name you chose to describe and distinguish the server-level firewall setting.
start_ip_address varchar(45) The lowest IP address in the range of the server-level firewall setting. IP addresses equal to or greater than this can attempt to connect to the [!INCLUDEssSDS] server. The lowest possible IP address is 0.0.0.0.
end_ip_address varchar(45) The highest IP address in the range of the server-level firewall setting. IP addresses equal to or less than this can attempt to connect to the [!INCLUDEssSDS] server. The highest possible IP address is 255.255.255.255.

Note: Azure connection attempts are allowed when both this field and the start_ip_address field equals 0.0.0.0.
create_date datetime UTC date and time when the server-level firewall setting was created.

Note: UTC is an acronym for Coordinated Universal Time.
modify_date datetime UTC date and time when the server-level firewall setting was last modified.

Remarks

To return information about the database-level firewall settings associated with your [!INCLUDE ssazure-sqldb], use sys.database_firewall_rules (Azure SQL Database).

Permissions

Read-only access to this view is available to all users with permission to connect to the master database.

See also