I would like to create Python tool for deleting field using SQl Expression.
Can anyone suggest me.
Did you look at the Delete Field code in the help?
Yes, I had a look at the Delete Field code, Its is useful, Thanks.
As Dan mentioned, there are code samples Delete Field—Help | ArcGIS for Desktop for deleting fields.
Are the Field names changing that require you to use a SQL statement for the field names? Or are you trying to query records and change the field value in the selected records? That would be a different process and I think would make more sense for using a query.
I would like to make query builder to select records and delete that selected recods.
code samples for query and delete are in the online help, just emulate
http://desktop.arcgis.com/en/desktop/latest/tools/data-management-toolbox/make-query-table.htm
This is my tool. When I click ok then the selected fields should only deleted.
Yes I am trying to delete the field values instead of field using SQl Statement.
This is my tool.
If your trying to delete the values not the field then use a selection tool and then use field calculator to clear the fields.
Ok, Thanks.