AnsweredAssumed Answered

SQL Select to get a subtype value from an ARC Database

Question asked by ChrisWhittaker_SSWater on Jun 22, 2018
Latest reply on Jun 22, 2018 by RRobichaux-esristaff

Hi,

 

we are migrating from a legacy Oracle database to a SQL database and as such need to ensure the data in both the source and target systems migrate in full.

 

in the target database we have various tables that hold valuetypes of items that are held as numbers rather than the full description of the type.

 

Q> Does anyone know where the subtype description may be held in the database as I can not seem to find them in the specific table.

 

in the example I will post via a screenshot I am selecting a type of valve in the valve table

Outcomes