topic Re: arcpy.Describe(relationshipclass) doesn't include key fields. in Python Questions

arcpy.Describe(relationshipclass) doesn't include key fields.

MichaelAdornetto — Fri, 20 May 2011 04:38:27 GMT

I'm attempting to write a script to read the relationship classes from one geodatabase to another. These tables have identical feature and object classes.

I should be able to select the relationshipclass in the source, use arcpy.Describe on them and get the parameter I'll need to perform an arcpy.createRelationshipClass_management. Except the describe does not give me any access Primary / Foreign key information according to the documentation. Is there away to get these field names because without it I can't recreate the relationship class.

Re: arcpy.Describe(relationshipclass) doesn't include key fields.

HenryColomb — Fri, 20 May 2011 13:44:23 GMT

Hello Michael
I am working on the same thing and encountered the same problem. If you figure it out please post your solution as will I. This is not the first time Ive started out with python for a task and had to go back to ArcObjects.
Henry

Re: arcpy.Describe(relationshipclass) doesn't include key fields.

JohnGravois — Mon, 23 May 2011 15:44:19 GMT

Currently Python does not have access to the following relationship class properties

OriginPrimaryKey
OriginForeignKey
DestinationPrimaryKey
DestinationForeignKey

The tracking number of this enhancement is [NIM048192 access to relationship class key properties in Python]. The status of the enhancement is currently "deferred", which means our development team will reconsider implementing it in our next major release. Please contact Esri Technical Support for more information or to add your name to the list of customers requesting this functionality.

Re: arcpy.Describe(relationshipclass) doesn't include key fields.

JeffButurff — Fri, 18 Oct 2013 14:03:09 GMT

I know this is an old thread, but can anyone provide an updated status on this "enhancement"? NIM048192

I'm trying to write a python script that copies feature classes and relationships across from one GDB to another. But without access to the KEY fields on the relationship, I can't recreate the relates...

Re: arcpy.Describe(relationshipclass) doesn't include key fields.

brettangel — Fri, 22 Nov 2013 19:49:31 GMT

Did anybody ever find a solution to this?

Re: arcpy.Describe(relationshipclass) doesn't include key fields.

JeffButurff — Sat, 23 Nov 2013 00:33:55 GMT

Nope, never found a solution. As far as I know, it's still an "enhancement request".

Haven't tested at 10.2, so I don't know if it's been fixed there.

Re: arcpy.Describe(relationshipclass) doesn't include key fields.

NeilAyres — Mon, 25 Nov 2013 05:49:11 GMT

Doesn't this give you the functionality you are looking for...
arcpy describe relationshipclass properties
http://resources.arcgis.com/en/help/main/10.2/#/RelationshipClass_properties/018v0000002n000000/
Cheers,
N

Re: arcpy.Describe(relationshipclass) doesn't include key fields.

JeffButurff — Mon, 25 Nov 2013 10:20:29 GMT

GSCUser85, thanks for the response. However, if you look closely at the docs, you'll notice the most important piece of a relationship class is missing: the key fields. We need the key fields for both primary and foreign keys.

Re: arcpy.Describe(relationshipclass) doesn't include key fields.

JamesCrandall — Mon, 25 Nov 2013 11:10:11 GMT

I know this is an old thread, but can anyone provide an updated status on this "enhancement"? NIM048192

I'm trying to write a python script that copies feature classes and relationships across from one GDB to another. But without access to the KEY fields on the relationship, I can't recreate the relates...

Have you reviewed any of these?

http://forums.arcgis.com/threads/64318-Detect-Relationship-in-Feature-Class-or-Table
http://gis.stackexchange.com/questions/50846/copy-two-datasets-that-particpate-in-the-same-relationship-class
http://resources.arcgis.com/en/help/main/10.1/index.html#//00170000015s000000

Re: arcpy.Describe(relationshipclass) doesn't include key fields.

JillianPenney — Sat, 11 Dec 2021 14:54:06 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: arcpy.Describe(relationshipclass) doesn't include key fields.

ChrisDiMeo — Wed, 29 Mar 2017 01:34:33 GMT

Hi -

Bumping this thread with a related question.

I'm trying to automate creating relationship classes in python (ArcGIS 10.2.1). I am able to get most of the information I need via the Describe call as shown in previous posts. I'd like to get the properties of existing RC's and automate recreating them using the original properties (copy/paste of data not an option).

My issue is that I'm not able to return the Relationship Rules (eg. desc.relationshipRules) as decribed here:

RelationshipClass properties—Help | ArcGIS for Desktop

The documentation is at 10.3 and I am working at 10.2

You can see below that I'm able to return all the properties available for this particular rel class except the Relationship Rules, which, I know exist (also see below).

Has anyone tried to return these relationship rules? Tried to recreate via python? Any success?

Thanks,

Chris