Create a domain from the existing values in a table

Summary

A domain is a declaration of acceptable attribute values. Using domains helps ensure data integrity by limiting the choice of values for a particular field. In some cases, the values are pre-defined in a table and users want to set the values to a domain so that only the values within the domain are valid for the field.

The instructions provided describe how to create a domain from the existing values in a table.

Procedure

Note:
Ignore if the Error 000800 is displayed.

1. In the Catalog window, navigate to System Toolboxes > Analysis Tools > Statistics > Summary Statistics.
2. Select the feature class as the input table.
3. Select the output table location.
4. Select the required field as the statistics field.
5. Click the field under the Statistics Type column, and select FIRST from the drop-down list.
6. Select the same field as the case field.
   
7. Click OK. A new table is created.

Note:
Leave Domain Name, Domain Description, and Update Option at default values.

1. In the Catalog window, navigate to System Toolboxes > Data Management Tools > Domains > Domain To Table.
2. Select the output from the Summary Statistics tool as the input table.
3. Select the same field used in the Summary Statistics tool as the code field.
4. Select the same field as the description field.
5. Select the file geodatabase as the input workspace.
6. Click OK.
   

1. In the Catalog window, right-click the feature class to which the domain is assigned in the file geodatabase, and click Properties.
2. Click the Fields tab.
3. Select the field, click the empty field next to Domain, and select the domain from the drop-down list.
   
4. Click OK.