ArcGIS Help 10.1 - Domain To Table (Data Management)

Summary

Creates a table from an attribute domain.

Usage

Creating a table from an attribute domain allows for additional editing of the table in ArcMap. For example, a table could be created from a coded value domain, additional code values could be added to the coded value list, and the Table To Domain tool could be used to update the original domain.
Workspace domains can also be managed in ArcCatalog or the Catalog window. Domains can be created and modified through the Domains tab on the Database Properties dialog box.

Syntax

DomainToTable_management (in_workspace, domain_name, out_table, code_field, description_field, {configuration_keyword})

Parameter	Explanation	Data Type
in_workspace	The workspace containing the attribute domain to be converted to a table.	Workspace
domain_name	The name of the existing attribute domain.	String
out_table	The table to be created.	Table
code_field	The name of the field in the created table that will store code values.	String
description_field	The name of the field in the created table that will store code value descriptions.	String
configuration_keyword (Optional)	For SDE tables, the custom storage keywords for creating the table.	String

Code Sample

Domain to Table Example (Python Window)

The following Python window script demonstrates how to use the DomainToTable function.

import arcpy
from arcpy import env
env.workspace = "C:/data"
arcpy.DomainToTable_management("montgomery.gdb", "DistDiam", "diameters", "code", "descript")

Domain to Table Example 2 (Stand-alone Script)

This stand-alone script uses the DomainToTable function as part of a workflow to edit a domain.

# Name: RemoveDomainsExample.py
# Purpose: Update an attribute domain to constrain valid pipe material values
# Author: ESRI

# Import system modules
import arcpy, os
from arcpy import env
 
try:
    # Set the workspace (to avoid having to type in the full path to the data every time)
    env.workspace = "data"
 
    # set local parameters
    inFeatures = "Montgomery.gdb/Water/DistribMains"
    inField = "MATERIAL"
    dWorkspace = "Montgomery.gdb"
    domName = "Material"
    codedValue =  "ACP: Asbestos concrete"
    codeField = "TYPE"
    fieldDesc= "DESRIPT"
    # Process: Remove the constraint from the material field
    arcpy.RemoveDomainFromField_management(inFeatures, inField)
 
    # Edit the domain values
    # Process: Remove a coded value from the domain
    arcpy.DeleteCodedValueFromDomain_management(dWorkspace, domName, codedValue)
 
    # Process: Create a table from the domain to edit it with ArcMap editing tools
    arcpy.DomainToTable_management(dWorkspace, domname, dWorkspace + os.sep + domname , codeField, fieldDesc)
 
    # Process: Delete the domain
    arcpy.DeleteDomain_management(dWorkspace, domName)
 
    # Edit the domain table outside of geoprocessing
    # and then bring the domain back in with the TableToDomain process
 
except Exception, e:
    # If an error occurred, print line number and error message
    import traceback, sys
    tb = sys.exc_info()[2]
    print "Line %i" % tb.tb_lineno
    print e.message

Environments

Output CONFIG Keyword, Current Workspace, Scratch Workspace, Auto Commit

Licensing Information

ArcGIS for Desktop Basic: Yes

ArcGIS for Desktop Standard: Yes

ArcGIS for Desktop Advanced: Yes

11/18/2013

Domain To Table (Data Management)