PROBLEM
Not able to delete long integer type fields named OID or ROWID in geodatabase feature classes or tables
Description
Geodatabase feature classes or tables containing long integer type fields named OID or ROWID cannot be deleted.
Cause
Data exported from a joined feature class or table to a geodatabase may appear to contain more than one ObjectID field. One field will have a field type of ObjectID and the other, usually named OID or ROWID, will have a type of long integer.
The REQUIRED property is set for the exported long integer OID fields. Since required fields can't be deleted, it is not possible to delete these fields.
Solution or Workaround
Before exporting, use table or layer properties in ArcMap to make the OID or ROWID field invisible.Right-click on the table or layer in ArcMap table of contents > properties.
Under the Fields tab > click on the ObjectID or ROWID field > uncheck the visible box![[O-Image] Field visible](https://webapps-cdn.esri.com/CDN/support-site/technical-articles-images/000004368/00N39000003LL2C-0EM39000000wcbo.png)
> click OK.
Article ID:000004368
- ArcMap 8 x
Get help from ArcGIS experts
Download the Esri Support App
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback