topic Primary/Foreign Key from Relationship Class in Python Questions

Primary/Foreign Key from Relationship Class

brettangel — Sat, 11 Dec 2021 23:34:18 GMT

I was able to get the relationshipClassNames property to work (thanks Xander!), but did not realize the relationshipClass property did not have a primary and foreign key field.

arcpy.Describe(arcpy.MakeTableView_management(table, table + "_view")).relationshipClassNames:

I tried using some code from this thread, but get an empty value [].

fields = arcpy.Describe(relationshipName).fields
print fields

Any ideas on how to get the primary/foreign keys from a relationship class?

Re: Primary/Foreign Key from Relationship Class

brettangel — Fri, 22 Nov 2013 20:44:43 GMT

The answer from tech support is the primary/foreign key properties are not exposed in Python, but there is an enhancement request already in for this.

Re: Primary/Foreign Key from Relationship Class

JillianPenney — Mon, 25 Nov 2013 19:29:44 GMT

Brett,

You may have been on one of the other threads where I posted this response, but incase you missed it, this functionality will be included in the 10.2.1 release via arcpy.Describe(<relclass>).OriginClassKeys and arcpy.Describe(<relclass>).DestinationClassKeys.

Jill

Re: Primary/Foreign Key from Relationship Class

brettangel — Mon, 02 Dec 2013 13:37:35 GMT

Thanks Jill!