Small and medium business | Business Central, N...

UNABLE TO DELETE UNUSED TABLES FROM CODE IN DYNAMICS 365 BUSINESS CENTRAL

(5) Share

Report

Posted on by AK-02040815-0

Hi Team,

I was doing code refactor and found that in my code few tables are obsoleted, and the obsolete state is removed from few years. There are no references of the table as well. On deleting the table and running the AL validation for "US" it gives validation error as attached. Can you please help me is there any way that i can remove unused tables and unused table fields and get rid of the AL validation as well.

In case of any questions, you may email me on - ankit@binarystream.com

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Khushbu Rajvi. 20,363 Super User 2025 Season 2 on at

Like (2)

Report

Hope this helps:https://community.dynamics.com/forums/thread/details/?threadid=f0a835a4-471d-41af-8a55-fe40c240ce63

https://community.dynamics.com/forums/thread/details/?threadid=19486805-c338-447b-9c73-abfac9c3e378

https://learn.microsoft.com/en-us/dynamics365/business-central/admin-data-retention-policies

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,213 Most Valuable Professional on at

Like (1)

Report

Hi, good day
I hope this can help you, and give you some hints.

SQL schema cleanup in BC – The BC Docs Librarian

Best Regards
Gerardo

Was this reply helpful? Yes No
Suggested answer

Ramesh Kumar 7,527 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

Obsoleting the field/tables is right way to remove. I hope below can help you.

https://yzhums.com/18755/

https://learn.microsoft.com/en-us/dynamics365/business-central/admin-data-retention-policies

Thanks

Ramesh

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

If your app is for appsource then you need to mark first as Obsolete and then in the next version you can remove them, if that is for PTE then you can use the synchronization to force it.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,331 Super User 2025 Season 2 on at

Like (0)

Report

Hi, hope the following helps as well.

AppSourceCop Error AS0001 - Business Central | Microsoft Learn

Thanks.

ZHU

Was this reply helpful? Yes No
Vahid Ghafarpour 12,090 Super User 2025 Season 2 on at

Like (1)

Report

If any of the responses helped resolve your issue, please take a moment to mark the best answer. This helps others in the community quickly find solutions to similar problems.

To do this, simply click the "Does this answer your question?" button on the most helpful response and like the helpful posts. If your issue is still unresolved, feel free to provide more details so the community can assist further!

Thanks for being an active part of the Dynamics 365 Community!

Was this reply helpful? Yes No