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

Removing tables is not allowed unless they are temporary or are being moved by migration to another app

(0) Share

Report

Posted on by Nadeer

After I extended an exist table in BC and publish it, then I removed the extended table again and published code again, I received this error:

Removing tables is not allowed unless they are temporary or are being moved by migration to another app.

I searched in community but did not find how to fix the issue, but I follow the solution provided here by Kalman Beres:

https://github.com/Microsoft/AL/issues/3479#issuecomment-419914532

And that fixed my issue, But I hope to know how to avoid such an issue in future, and what is the best practice if someone can help.

Thanks in advance,

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Mohana Yadav 60,993 Super User 2025 Season 2 on at

Like (1)

Report

Obsoleting the fields/tables is the proper way to remove.

Was this reply helpful? Yes No
Anita75 1,165 on at

Like (0)

Report

If you are in a Sandbox without actual data in new fields you can delete when uninstalling

Was this reply helpful? Yes No
Y_A 395 on at

Like (0)

Report

Hi Nadeer , In this case, were you removing a table extension (extending a standard BC table) or a new table?

In my case I have a table extension that is extending the Item Cross Reference table that is being deprecated by Microsoft and I have to remove the table extension. I have already marked the fields as obsolete and moved the data to a new table extension but I cannot remove the table extension itself and it is issuing warnings. The Table extension object itself cannot be marked as obsolete as the property does not exist.

Any help on how I can remove a table extension, maybe? Mohana Yadav

Thanks!

Was this reply helpful? Yes No
Suggested answer

Teddy Herryanto (Th... 14,284 Super User 2025 Season 2 on at

Like (1)

Report

If you are publishing through VS Code, change your schemaUpdateMode to ForceSync.

If you are publishing through Extension Management, change the Schema Sync Mode to Force.

Was this reply helpful? Yes No
Suggested answer

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

Like (1)

Report

Hi, hope the following will help.

https://yzhums.com/17671/

https://yzhums.com/18755/

Thanks.

ZHU

Was this reply helpful? Yes No