ArcGIS Desktop

  • Documentation
  • Support

  • My Profile
  • Help
  • Sign Out
ArcGIS Desktop

ArcGIS Online

The mapping platform for your organization

ArcGIS Desktop

A complete professional GIS

ArcGIS Enterprise

GIS in your enterprise

ArcGIS for Developers

Tools to build location-aware apps

ArcGIS Solutions

Free template maps and apps for your industry

ArcGIS Marketplace

Get apps and data for your organization

  • Documentation
  • Support
Esri
  • Sign In
user
  • My Profile
  • Sign Out

Help

  • Home
  • Get Started
  • Map
  • Analyze
  • Manage Data
  • Tools
  • More...

What type of data can be edited using SQL?

  • What can be edited using SQL
  • What cannot 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

  • Is_Simple
  • What is SQL?
  • What is an ObjectID?
  • An overview of geodatabase system tables

ArcGIS Desktop

  • Home
  • Documentation
  • Support

ArcGIS Platform

  • ArcGIS Online
  • ArcGIS Desktop
  • ArcGIS Enterprise
  • ArcGIS for Developers
  • ArcGIS Solutions
  • ArcGIS Marketplace

About Esri

  • About Us
  • Careers
  • Insiders Blog
  • User Conference
  • Developer Summit
Esri
Tell us what you think.
© Copyright 2016 Environmental Systems Research Institute, Inc. | Privacy | Legal