Select to view content in your preferred language

Any issues deleting a single feature w/ SQL rather than SDE API?

866
1
03-21-2011 09:32 AM
ChristinaKepler
Emerging Contributor
Are there any known issues with deleting a feature/row from an SDE feature class with a straight DB 'delete' SQL command, outside of the SDE API?  Would that leave any SDE artifacts around that we don't want?
0 Kudos
1 Reply
VinceAngelo
Esri Esteemed Contributor
There's a lot a variables to be resolved before a simple "No" can be given.

Is the table versioned?

Does the table participate in geodatabase topologies, networks, or object behaviors?

Does the layer use SDEBINARY/SDELOB storage?  If so, is it in LOAD_ONLY I/O mode?

In general, there are triggers to maintain referential integrity, but any of the above
could preclude the safe use of DELETE.  Note that the same problems would exist
if you used the ArcSDE API (SE_stream_delete_from_table is just a wrapper on
a SQL delete), but the I/O mode problem would probably be caught at the API.

- V
0 Kudos