Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
MSDN Library

sys.database_firewall_rules (Azure SQL Database)

Returns information about the database-level firewall settings associated with your Microsoft Azure SQL Database. Database-level firewall settings are particularly useful when using contained database users. For more information, see Contained Database Users - Making Your Database Portable.

Applies to: Azure SQL Database.

The sys.database_firewall_rules view contains the following columns:

Column name

Data type

Description

id

INTEGER

The identifier of the database-level firewall setting.

name

NVARCHAR(128)

The name you chose to describe and distinguish the database-level firewall setting.

start_ip_address

VARCHAR(50)

The lowest IP address in the range of the database-level firewall setting. IP addresses equal to or greater than this can attempt to connect to the SQL Database instance. The lowest possible IP address is 0.0.0.0.

end_ip_address

VARCHAR(50)

The highest IP address in the range of the firewall setting. IP addresses equal to or less than this can attempt to connect to the SQL Database instance. The highest possible IP address is 255.255.255.255.

Note Note

Windows 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 database-level firewall setting was created.

modify_date

DATETIME

UTC date and time when the database-level firewall setting was last modified.

To remove a database firewall rule, use sp_delete_database_firewall_rule (Azure SQL Database). To set a firewall rule for all of SQL Database, see sp_set_firewall_rule (Azure SQL Database). To return information about existing database firewall rules, query sys.database_firewall_rules (Azure SQL Database).

This view is available in the master database and in each user database. Read-only access to this view is available to all users with permission to connect to the database.

Community Additions

Show:
© 2015 Microsoft