Create relate between FC and Table in SQL Server databases

05-30-2019 11:54 AM
Occasional Contributor III

Hello everyone,

Is there a way to create a relationship  between a FC in a SDE SQL Server database and a table in a r regular SQL Server database?

Do I have to copy the table in SDE to create a relationship class  -arcpy.CreateRelationshipClass_management.

Using ArcGIS Online. we would like to show utility features and their corresponding work orders records stored in a regular MS SQL database. This is a one to many relationship.  


0 Kudos
1 Reply
Esri Contributor

Hi Jose,

To create a geodatabase relationship class, you need to copy table to geodatabase contains feature class. Or register with geodatabase, if the table is present in the same geodatabase of feature class.



0 Kudos