Table Definition - DNSZone

Field Type Read-only Description
ID Integer Yes Primary Key (unique ID) for row
Name Char Yes* Domain name / Network Address. *Must be specified for INSERT statements
Reverse Integer Yes Reverse Lookup Zone (0 = No, 1 = Yes)
Type Integer Yes Zone type (1 = Primary, 2 = Secondary, 3 = Stub)
DSIntegrated Integer Yes* Zone is Active Directory integrated (0 = No, 1 = Yes). *Must be specified for INSERT statements
Scavenge Integer Yes Stale resource record scavenging active (0 = No, 1 = Yes)
ScavengeNoRefresh Integer No Scavenging no-refresh interval (in seconds)
ScavengeRefresh Integer No Scavenging refresh interval (in seconds)
FileName Char Yes Zone file name
Master Char Yes Master server (for secondary and stub type zones. NULL for primary zones)
Paused Integer No Zone is paused (0 = No, 1 = Yes)

Usage Notes

  1. INSERT and DELETE statements run against the 'DNSZone' table will create and delete DNS zones on the target server, respectively
  2. As noted, the 'Name' and 'DSIntegrated' fields must be specified, at minimum, for INSERT statements. Any non read-only field may also be specified in INSERT statements to be applied to newly created zones
  3. To INSERT a reverse lookup zone, name should be formatted in reverse format with "in-addr.arpa" TLD suffix. E.g. "0.168.192.in-addr.arpa" for the 192.168.0/24 network
  4. INSERT statements run against the 'DNSZone' table will create the corresponding domain entry in the 'DNSDomain' table
  5. DELETE statements run against the 'DNSZone' table will delete corresponding entries in the 'DNSDomain' and 'DNSRecord' tables

© 2014 Synthetic Dreams Back to Top

Back to Top

Follow Us

Twitter icon
Facebook icon
LinkedIn icon

Tweets from the Team