What type of data can be edited using SQL?
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 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 (or row IDs) that are maintained by ArcGIS or the DBMS
- Attributes that participate in the following geodatabase functionality:
- Annotation feature classes and feature-linked annotation
- Archived data
- Cadastral or parcel fabrics
- Domains
- Geodatabase replication
- Geometric networks
- Network datasets
- Relationship classes
- Representations
- Schematic datasets
- Subtypes
- Survey datasets
- Terrains
- Topology
Related Topics
6/19/2015