olisterr.tech | Blog on Dynamics 365 Business Apps, NAV / Business Central, Power Platform and Azure

Introduction: Imagine a scenario where as per the requirements provided by your clients, you have set up the Database structure in NAV/Business Central. Then comes a requirement in Phase 2 which completely redefines the database structure which was provided by you and you need to delete a few fields in a table and move it to another table. Pre-requisites: Microsoft Dynamics NAV Microsoft Dynamics Business Central Books & References: https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/properties/devenv-obsoletestate-property Solution: 1. In Microsoft Dynamics NAV, there was a flexibility to delete fields, tables, and keys and using  Force-Sync, you can directly delete the field, table, and keys from SQL Database. 2. Whereas in Microsoft Dynamics Business Central, you cannot delete the fields, keys, and tables. In order to deploy this deleted change, you need to mention this field, table, and keys with Obsolete State Removed. ...