Using SQL DELETE

788
2
Jump to solution
01-27-2017 06:59 AM
AlbertoAloe
Occasional Contributor

Hi guys,

just to be sure...

It is ok to delete features/rows in a non versioned feature class/table using SQL DELETE, right ?

Alberto 

0 Kudos
1 Solution

Accepted Solutions
VinceAngelo
Esri Esteemed Contributor

Yes, of course.  The only exception was when using SDEBINARY geometry storage, when a layer was in load_only I/O mode, where the triggers were disabled, so that a DELETE would not remove the Sn and Fn rows. Most modern databases use ST_Geometry or native SQL storage, so this doesn't even apply.

- V

View solution in original post

2 Replies
VinceAngelo
Esri Esteemed Contributor

Yes, of course.  The only exception was when using SDEBINARY geometry storage, when a layer was in load_only I/O mode, where the triggers were disabled, so that a DELETE would not remove the Sn and Fn rows. Most modern databases use ST_Geometry or native SQL storage, so this doesn't even apply.

- V

AdamZiegler1
Esri Contributor

In addition to what Vince said, make sure it's not participating in a relationship class.

-Adam Z