Select to view content in your preferred language

SQL Table to Domain

627
4
Jump to solution
08-22-2023 02:38 PM
vijaybadugu
Occasional Contributor II

We have plenty of Non Spatial SQL Tables with two fields one is code and other is description with unique 100s of records. which is used in other applications. Is there any way to use same table as domain and assign them to fields in ArcGIS Pro? 

1 Solution

Accepted Solutions
MarceloMarques
Esri Regular Contributor

You need to convert your table into a Geodatabase Domain.
Table To Domain (Data Management)—ArcGIS Pro | Documentation

| Marcelo Marques | Principal Product Engineer | Esri |
| Cloud & Database Administrator | OCP - Oracle Certified Professional |
I work with Enterprise Geodatabases since 1997.
“ I do not fear computers. I fear the lack of them." Isaac Isimov

View solution in original post

0 Kudos
4 Replies
MarceloMarques
Esri Regular Contributor

You need to convert your table into a Geodatabase Domain.
Table To Domain (Data Management)—ArcGIS Pro | Documentation

| Marcelo Marques | Principal Product Engineer | Esri |
| Cloud & Database Administrator | OCP - Oracle Certified Professional |
I work with Enterprise Geodatabases since 1997.
“ I do not fear computers. I fear the lack of them." Isaac Isimov
0 Kudos
vijaybadugu
Occasional Contributor II

Table to domain tool is not accessing SQL tables ?

0 Kudos
clt_cabq
Occasional Contributor III

in ArcGIS Pro search for Table to Domain in the geoprocessing tools, this should do what you are wanting. This will create a domain in your geodatabase that you can then assign to the appropriate table/field. You may have to work with your GIS data to make sure the existing values correspond exactly to what is in your new domain. 

0 Kudos
vijaybadugu
Occasional Contributor II

Thanks a lot for your answers. I just did converting table to csv and used same tool to convent to domain

0 Kudos