What can be edited using SQL
You can use SQL from a third-party client 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 not 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*
- Attribute rules
- Geometric networks
- Parcel fabrics
- Network datasets
- Relationship classes
- Schematic datasets
- Survey datasets
- Utility networks
- Versioned data**
*You cannot edit archived data directly, but you can edit through an archive view.
**You cannot edit versioned data directly using SQL. If your data uses traditional versioning, you can edit through a versioned view. If your data uses branch versioning, you cannot edit using SQL.