sys.firewall_rules (Azure SQL Database)

Returns information about the server-level firewall settings associated with your [!INCLUDEmsCoName] [!INCLUDEssSDSfull].

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 returns information about the database-level firewall settings associated with your Microsoft Azure SQL Database, use sys.database_firewall_rules (Azure SQL Database).

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