topic Re: Create relate between FC and Table in SQL Server databases in Geodatabase Questions https://community.esri.com/t5/geodatabase-questions/create-relate-between-fc-and-table-in-sql-server/m-p/818892#M3608 <HTML><HEAD></HEAD><BODY><P>Hi Jose,</P><P></P><P>To create a geodatabase relationship class, you need to copy table to geodatabase&nbsp;contains feature class. Or register with geodatabase, if the table is present in the same geodatabase&nbsp;of feature class.</P><P></P><P>Thanks,</P><P>Biraja</P></BODY></HTML> Fri, 31 May 2019 23:50:25 GMT BirajaNayak 2019-05-31T23:50:25Z Create relate between FC and Table in SQL Server databases https://community.esri.com/t5/geodatabase-questions/create-relate-between-fc-and-table-in-sql-server/m-p/818891#M3607 <HTML><HEAD></HEAD><BODY><P>Hello everyone,</P><P></P><P>Is there a way to create&nbsp;a relationship &nbsp;between a FC in a SDE SQL Server database and a table in a r regular SQL Server database?</P><P></P><P>Do I have to&nbsp;copy the table in SDE to create a relationship class&nbsp;&nbsp;-<SPAN style="color: #6f008a; font-family: Consolas; font-size: small;">arcpy</SPAN><SPAN style="font-family: Consolas; font-size: small;">.CreateRelationshipClass_management</SPAN>.</P><P></P><P>Using ArcGIS Online. we would like to show utility features and their corresponding work orders records stored in a regular MS SQL database.&nbsp;This is a one to many relationship.&nbsp;&nbsp;</P><P></P><P></P><P></P><P></P><P>.</P></BODY></HTML> Thu, 30 May 2019 18:54:36 GMT https://community.esri.com/t5/geodatabase-questions/create-relate-between-fc-and-table-in-sql-server/m-p/818891#M3607 JoseSanchez 2019-05-30T18:54:36Z Re: Create relate between FC and Table in SQL Server databases https://community.esri.com/t5/geodatabase-questions/create-relate-between-fc-and-table-in-sql-server/m-p/818892#M3608 <HTML><HEAD></HEAD><BODY><P>Hi Jose,</P><P></P><P>To create a geodatabase relationship class, you need to copy table to geodatabase&nbsp;contains feature class. Or register with geodatabase, if the table is present in the same geodatabase&nbsp;of feature class.</P><P></P><P>Thanks,</P><P>Biraja</P></BODY></HTML> Fri, 31 May 2019 23:50:25 GMT https://community.esri.com/t5/geodatabase-questions/create-relate-between-fc-and-table-in-sql-server/m-p/818892#M3608 BirajaNayak 2019-05-31T23:50:25Z