idea Alter Field should be able to do everything Fields View can do (such as change the domain) in ArcGIS Pro Ideas

Alter Field should be able to do everything Fields View can do (such as change the domain)

Bud — Fri, 16 Aug 2024 15:20:38 GMT

ArcGIS Pro 2.9.5; Oracle 18c 10.7.1 EGDB:

The Fields View can modify the following properties of an empty FC:

Data Type
Allow NULLs
Domain
Default value

But the Alter Field geoprocessing tool can't change those properties.

It would be more intuitive if the Alter Fields tool had equivalent functionality to the Fields View.

Re: Alter Field should be able to do everything Fields View can do (such as change the domain)

SSWoodward — Fri, 16 Aug 2024 15:43:13 GMT

Thanks for the Idea @Bud,

You're correct alter field does not have an option to assign a domain. This is by design.

Alter field is used to set properties of the field, like name, alias, length, etc. which cannot differ between subtypes. Properties like domain assignment, and default value, on the other hand, can be set uniquely per subtype and so have separate tools. Assign Domain to Field and Assign Default to Field require the ability to target specific subtypes and so are discrete tools.

Re: Alter Field should be able to do everything Fields View can do (such as change the domain)

Bud — Fri, 16 Aug 2024 15:37:09 GMT

@SSWoodward

Makes sense. Would it help if I changed the idea title to "Alter Field — Change field Data Type and Allow NULL"? Or something else?

Re: Alter Field should be able to do everything Fields View can do (such as change the domain)

SSWoodward — Fri, 16 Aug 2024 15:44:30 GMT

You also mentioned that you would like the tool to be able to change the field type and nullability of a field. These options are already offered in the tool. Selecting an input class will display them if the table meets the requirements for making these types of schema changes.

Re: Alter Field should be able to do everything Fields View can do (such as change the domain)

Bud — Fri, 16 Aug 2024 15:38:55 GMT

@SSWoodward Ah, ok. Feel free to close.

Re: Alter Field should be able to do everything Fields View can do (such as change the domain)

SSWoodward — Fri, 16 Aug 2024 15:40:43 GMT

Looks like you beat me to post while I was grabbing a screen shot. If you were to change the idea to that I would close as already offered.

Are you not seeing these options in your software?

Re: Alter Field should be able to do everything Fields View can do (such as change the domain) - Status changed to: Already Offered

SSWoodward — Fri, 16 Aug 2024 15:40:24 GMT

Thanks @Bud

Glad we could clear up that this functionality is already available in the current software.