Table does not get registered with SDE if a Foreign Key constraint is introduced to the table of SQL Server Spatial type.
上次发布: August 25, 2014ArcSDE/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.