topic Re: Alter Field tool missing option to change non-Null to Null field in ArcGIS Pro Questions

Alter Field tool missing option to change non-Null to Null field

AnnaSan1 — Tue, 06 Nov 2018 22:32:31 GMT

I am pretty sure the Alter Field tool had the ability to switch a field from Non-null to Allow Null field property in the past. But the check box for it is now missing. I am using version Pro 2.2.3. Where did it go? Any help is appreciated. I don't want to have to reconstruct my feature class if I don't have to.

Thank you,

Re: Alter Field tool missing option to change non-Null to Null field

DanPatterson_Retired — Tue, 06 Nov 2018 22:56:42 GMT

according to the help, the table has to be empty to change that property

Alter Field—Data Management toolbox | ArcGIS Desktop

Re: Alter Field tool missing option to change non-Null to Null field

AnnaSan1 — Tue, 06 Nov 2018 23:09:46 GMT

My feature class has no data or records in it.

Re: Alter Field tool missing option to change non-Null to Null field

DanPatterson_Retired — Tue, 06 Nov 2018 23:20:08 GMT

I guess a picture will show what is needed. There is only one field there that is 'nullable'

Re: Alter Field tool missing option to change non-Null to Null field

AnnaSan1 — Tue, 06 Nov 2018 23:31:07 GMT

Hmm. Odd. It is now showing up after I upgraded to 2.2.4. I still don't know why the checkbox for 'IsNullable ' didn't show up before though.

Thanks for your help anyway!

Re: Alter Field tool missing option to change non-Null to Null field

DanPatterson_Retired — Tue, 06 Nov 2018 23:42:49 GMT

Your image shows nothing selected or input, hence the option wouldn't show.

I did that screen in Pro 2.2.3... and I just updated to 2.2.4 and it is still there. Not the update, it is a sparse one and not related to your issue.

It wouldn't be there if there were no fields that were nullable like OBJECTID, SHAPE and its incarnates.

If there is a nullable field it appears, but disappears if you select a forbidden field.