laptop and a wrench

漏洞

Table does not get registered with SDE if a Foreign Key constraint is introduced to the table of SQL Server Spatial type.

上次发布: August 25, 2014 ArcSDE/Enterprise Geodatabase
漏洞 ID 编号 NIM042116
已提交February 3, 2009
上次修改时间April 2, 2025
适用范围ArcSDE/Enterprise Geodatabase
找到的版本9.3
操作系统Windows OS
操作系统版本2003
修正版本9.4
状态Fixed

解决办法

1. Create the table without foreign key constraint using the SQL Server Management Studio2. Register the table with SDE using sdelayer -o register3. Register the layer with geodatabase (using ArcCatalog > Right Click)4. Introduce the foreign key constraint using the SQL Server Management Studio5. Check the layer in ArcCatalog client (It was visible)Note: The layers created this way cannot be registered as Versioned for editing.

重现步骤

漏洞 ID: NIM042116

软件:

  • ArcSDE/Enterprise Geodatabase

当漏洞状态发生变化时获得通知

下载 Esri 支持应用程序

发现关于本主题的更多内容

获取来自 ArcGIS 专家的帮助

联系技术支持部门

下载 Esri 支持应用程序

转至下载选项