laptop and a wrench

Bug

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

Last Published: August 25, 2014 ArcSDE/Enterprise Geodatabase
Bug ID Number NIM042116
SubmittedFebruary 3, 2009
Last ModifiedApril 2, 2025
Applies toArcSDE/Enterprise Geodatabase
Version found9.3
Operating SystemWindows OS
Operating System Version2003
Version Fixed9.4
StatusFixed

Workaround

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.

Steps to Reproduce

Bug ID: NIM042116

Software:

  • ArcSDE/Enterprise Geodatabase

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Esri Community

Search for related information

Training

Find training related to this topic

ArcGIS Ideas

Explore ideas and give feedback

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options