topic Re: How to get all relationshipclass properties using Python in Geoprocessing Questions

How to get all relationshipclass properties using Python

StevePeaslee — Wed, 09 Jan 2013 12:09:35 GMT

I need to get all the properties for a geodatabase relationshipclass. I can use a Python script to get most of the properties via the geoprocessing "Describe" but unless I'm missing something, the names of the primary and foreign key fields aren't exposed to this method.

Can someone please point me in the right direction? There has to be a way.

-Steve

Re: How to get all relationshipclass properties using Python

brettangel — Fri, 22 Nov 2013 19:53:12 GMT

Did you ever find a solution to this?

Re: How to get all relationshipclass properties using Python

JillianPenney — Sun, 12 Dec 2021 01:10:28 GMT

At 10.2.1 release, it will be possible to obtain the origin and destination class keys via python using the Describe function.

You can use:

arcpy.Describe(<relationshipclass>).OriginClassKeys  or
arcpy.Describe(<relationshipclass>).DestinationClassKeys

The result returned will look something like this:

[(u'OBJECTID', u'OriginPrimary', u''), (u'ParcelID', u'OriginForeign', u'')]
[(u'id', u'DestinationPrimary', u''), (u'RenterID', u'DestinationForeign', u'')]

Hope this helps!

Re: How to get all relationshipclass properties using Python

StevePeaslee — Tue, 26 Nov 2013 11:01:07 GMT

Thanks Jill! Just have to be patient I guess.

-Steve