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)

Sort by

Suggested answer

Khushbu Rajvi. 22,342 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

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... 26,110 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

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,549 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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,278 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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 100,212 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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,258 on at

Like (1)

Report
Copy link

Link copied!

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