Finance | Project Operations, Human Resources, ...

What is the best solution for unused table field that is running on the production environment

(0) Share

Report

Posted on by Ozan

I'm working on D365 FO environment.

I have some unused table fields that I want to delete but I'm not sure this is good idea or bad because these fields have some data on production environment but these are meanless now.

If I delete fields what is exact result in a cloud based environment and on-primes?

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

ergun sahin 8,826 Moderator on at

Like (0)

Report

Of course you'll lose the data, but you obviously don't care anyway.

You need to pay attention to whether you use the relevant fields in codes, forms, table relations, delete actions (via relation), reports etc...

After deleting, do a full sync and then a full build of the model. If there is a model that references this model and is likely to use the fields, build it as well.

If there is no error after Build, it's ok, but in case of error, you have to examine and solve the objects one by one.
You can examine the places where they are used by right-clicking on the fields and "find references", but do not trust 100%, make sure to follow the steps I mentioned above.

Was this reply helpful? Yes No
André Arnaud de Cal... 300,966 Super User 2025 Season 2 on at

Like (0)

Report

Hi Ozan,

Can you tell more about these fields? Are they part of the standard application or is it part of a customization? If it is part of the standard, I wouldn't touch them.

Was this reply helpful? Yes No
Suggested answer

huijij 19,811 on at

Like (0)

Report

Hi Ozan,

What about the DEL_ prefix?

The DEL_ is a special prefix. It is an abbreviation for Deleted and is used for application objects that will be deleted. After an object is prefixed with DEL_, it will be supported for a release and then deleted in the next version of the product.

regards

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

The DEL_ prefix is useless in D365 since there are no more code upgrades between version updates. If the field and the data in it are really not needed for anything (and it's part of your customization model) you can simply remove the field in Visual Studio and deploy this change to prod via your normal release process.

Was this reply helpful? Yes No