What can be edited using SQL
You can use SQL to edit the following:
- Attributes of user-defined tables or feature classes in an enterprise geodatabase if those attributes do not participate in geodatabase functionality
- User-defined database tables that are not registered with the geodatabase
You can use the Is_Simple function to determine whether your data participates in most geodatabase functionality.
What cannot be edited using SQL
You can use SQL to read the following items, but do not use SQL to edit them:
- Geodatabase system tables
- ObjectIDs that are maintained by ArcGIS or the database management system
- Attributes that participate in the following geodatabase functionality:
- Annotation feature classes and feature-linked annotation
- Archived data*
- Domains
- Geometric networks
- Parcel fabrics
- Network datasets
- Relationship classes
- Representations
- Schematic datasets
- Subtypes
- Survey datasets
- Terrains
- Topology
- Versioned data**
*You cannot edit archived data directly, but you can edit through an archive view.
**You cannot edit versioned data directly, but you can edit through a versioned view.