Skip To Content

Table To Domain

Summary

Creates or updates a coded value domain with values from a table.

Usage

  • A domain can also be created with the Create Domain tool.

  • The standard delimiter for tabular text files with extensions .csv or .txt is a comma, and for files with a .tab extension, a tab. To use an input table with a nonstandard delimiter, you must first specify the correct delimiter used in the table using a schema.ini file.

Syntax

TableToDomain(in_table, code_field, description_field, in_workspace, domain_name, {domain_description}, {update_option})
ParameterExplanationData Type
in_table

The database table from which to derive domain values.

Table View
code_field

The field in the database table from which to derive domain code values.

Field
description_field

The field in the database table from which to derive domain description values.

Field
in_workspace

The workspace that contains the domain to be created or updated.

Workspace
domain_name

The name of the domain to be created or updated.

String
domain_description
(Optional)

The description of the domain to be created or updated. Domain descriptions of existing domains are not updated.

String
update_option
(Optional)

If the domain already exists, specifies how the domain will be updated.

  • APPENDAppends to the domain values from the database table.
  • REPLACEReplaces the values in the domain with values from the database table.
String

Derived Output

NameExplanationData Type
out_workspace

The updated input workspace.

Workspace

Code sample

TableToDomain example 1 (Python window)

The following Python window script demonstrates how to use the TableToDomain function in immediate mode.

import arcpy
from arcpy import env
env.workspace =  "C:/data"
arcpy.TableToDomain_management ("diameter.dbf",
                                "code",
                                "descript",
                                "montgomery.gdb",
                                "diameters",
                                "Valid pipe diameters")
TableToDomain example 2 (stand-alone script)

This stand-alone script uses the TableToDomain function as part of a workflow.

# Name: TableToDomain.py
# Description: Update an attribute domain to constrain valid pipe material values

# Import system modules
import arcpy
 
# Set the workspace (to avoid having to type in the full path to the data every time)
arcpy.env.workspace = "C:/data"

#Set local parameters
domTable = "diameter.dbf"
codeField = "code"
descField = "descript"
dWorkspace = "Montgomery.gdb"
domName = "diameters"
domDesc = "Valid pipe diameters"

# Process: Create a domain from an existing table
arcpy.TableToDomain_management(domTable, codeField, descField, dWorkspace, domName, domDesc)

Licensing information

  • Basic: Yes
  • Standard: Yes
  • Advanced: Yes

Related topics