Tables that are created in Oracle using ArcGIS Desktop are given an
OBJECTID field by default. The
OBJECTID field is assigned a
unique not-nullable index.
OBJECTID in an Oracle Geodatabase table have a
primary key constraint, by default?
I ask, because there can only be one field with a
primary key constraint per table. If the
OBJECTID does not have a
primary key constraint by default, I plan to add a
primary key constraint to a different field -- a field called
ID. I will use the
ID field in conjunction with a foreign key to enforce referential integrity at the database level. More info here.
primary key constraint is not to be confused with a
unique not-nullable index, a
candidate key or a
so-called relationship class "primary key".