Delete Attribute Field.

[RajP]

I would like to create Python tool for deleting field using SQl Expression.

Can anyone suggest me.

[DanPatterson_Retired]

Did you look at the Delete Field code in the help?

[RajP]

Yes, I had a look at the Delete Field code, Its is useful, Thanks.

[RebeccaStrauch__GISP]

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.

[RajP]

I would like to make query builder to select records and delete that selected recods.

[DanPatterson_Retired]

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

[RajP]

This is my tool. When I click ok then the selected fields should only deleted.

[RajP]

Yes I am trying to delete the field values instead of field using SQl Statement.

This is my tool.

[WesMiller]

If your trying to delete the values not the field then use a selection tool and then use field calculator to clear the fields.

[RajP]

Ok, Thanks.