Is there any way to use a cursor to delete a field using ArcPy?
I understand there are ways to use a cursor to delete records but I'm looking for a way to delete a field using a cursor.
-
1To delete a field you want arcpy.DeleteField_management resources.arcgis.com/en/help/main/10.2/index.html#//… but you can't do that with an active cursor because it locks the table.– Michael StimsonCommented Dec 16, 2019 at 1:30
-
@MichaelStimson I know that arcpy.DeleteField_management is an option but I was wondering if there is a way to achieve the same result with a cursor– Emma PascoeCommented Dec 16, 2019 at 1:33
-
@SonofaBeach I'm looking to delete the field from the table all together– Emma PascoeCommented Dec 16, 2019 at 1:33
Add a comment
|
1 Answer
No. You cannot use a cursor to delete a field from the schema of a table or feature class.
Cursors are used to view or edit data, not to alter the schema.
As @MichalStimson commented, you will need to use arcpy.DeleteField_management() to delete a field, and this cannot be done while there is an active cursor due to the cursor's lock on the table.
answered Dec 16, 2019 at 1:53
