AnsweredAssumed Answered

Best way to truncate and update non-spatial sql table

Question asked by thanos_cp78 on Feb 15, 2016
Latest reply on Feb 15, 2016 by vangelo-esristaff

Hi guys,


Need so inputs or advice on this, I have a sql server table that I need to sometimes truncate (completely wipe out data) or delete several rows from periodically. Then I also need to insert new rows based on the rows in a featureclass. I don't have a problem updating it,  I just use arcpy.da.InsertCursor but maybe this is not the best? For deleting a row or totally wiping out the table row, should I be using ArcSDESQLEXECUTE? I tried using data management>table>delete rows but it seems to be just applicable to esri tables and features.  I actually tried ArcSDESQLEXECUTE, passed a sql statement like "DELETE * FROM TABLE", but I keep hitting this "Sream" type error.


I need to setup my python code to run this kind of admin task on the sql table.


Hope you guys can give some tips. Thanks