topic Using SQL DELETE in ArcGIS Enterprise Questions https://community.esri.com/t5/arcgis-enterprise-questions/using-sql-delete/m-p/298215#M11477 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P>just to be sure...</P><P>It is ok to delete features/rows in a non versioned feature class/table using SQL DELETE, right ?</P><P></P><P>Alberto&nbsp;</P></BODY></HTML> Fri, 27 Jan 2017 14:59:22 GMT AlbertoAloe 2017-01-27T14:59:22Z Using SQL DELETE https://community.esri.com/t5/arcgis-enterprise-questions/using-sql-delete/m-p/298215#M11477 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P>just to be sure...</P><P>It is ok to delete features/rows in a non versioned feature class/table using SQL DELETE, right ?</P><P></P><P>Alberto&nbsp;</P></BODY></HTML> Fri, 27 Jan 2017 14:59:22 GMT https://community.esri.com/t5/arcgis-enterprise-questions/using-sql-delete/m-p/298215#M11477 AlbertoAloe 2017-01-27T14:59:22Z Re: Using SQL DELETE https://community.esri.com/t5/arcgis-enterprise-questions/using-sql-delete/m-p/298216#M11478 <HTML><HEAD></HEAD><BODY><P>Yes, of course.&nbsp; 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.</P><P></P><P>- V</P></BODY></HTML> Fri, 27 Jan 2017 15:08:34 GMT https://community.esri.com/t5/arcgis-enterprise-questions/using-sql-delete/m-p/298216#M11478 VinceAngelo 2017-01-27T15:08:34Z Re: Using SQL DELETE https://community.esri.com/t5/arcgis-enterprise-questions/using-sql-delete/m-p/298217#M11479 <HTML><HEAD></HEAD><BODY><P>In addition to what Vince said, make sure it's not participating in a relationship class.</P><P></P><P>-Adam Z</P></BODY></HTML> Fri, 27 Jan 2017 15:12:59 GMT https://community.esri.com/t5/arcgis-enterprise-questions/using-sql-delete/m-p/298217#M11479 AdamZiegler1 2017-01-27T15:12:59Z