Enforcing Unique Values in SDE

623
4
06-21-2022 04:20 PM
Labels (3)
aam
by
Occasional Contributor

Is there a way to enforce unique ID for a feature class in SDE when the user is adding new stuff to make sure the integrity of the data is not compromised.

I have editors who occasionally add new addresses into a feature class. There have been instances where duplicate addresses were entered. I am wondering if there is a way to enforce unique values.

Tags (1)
0 Kudos
4 Replies
Bud
by
Notable Contributor

You can add a unique index using the properties in Catalog. Composite unique indexes are also possible there too.

 

0 Kudos
aam
by
Occasional Contributor

Would this work in non versioned environment?

0 Kudos
Bud
by
Notable Contributor

Yes.

0 Kudos
VinceAngelo
Esri Esteemed Contributor

Keep in mind that there has not been an "in SDE" since the rewrite at 3.0.  Data resides "in" a database. All of the tools of the supported databases are available, though some of them may be incompatible with successful deployment (e.g. 64-bit integer types).

The versioning  model can be incompatible with UNIQUE values, since multiple conditional edits can exist in the ADDs table, and enforcement would be delayed until much too late.  You need a proactive validation process that looks for eventual duplicates.

- V

0 Kudos