Databse Table is not updated through DataStore publish

Question

Hi All, 
 Am working on 17.3 version. I have created a CDT using ' DataType Designer ' and created a 'Data Store' and published it. The table created successfully. 
 Now i have a change in my CDT to remove a Column, i have done it and mapped the CDT to Data Store and published the same. Everything goes well. 
 But the DB table is still showing the deleted column. Do you have any views on it. Please share. 
 
 Thanks, 
 Vamsi Krishna

aratim · Accepted Answer

Hi Vamsi, 
Whenever you will be making any changes to the CDT like adding a new column or updating the existing one then only such changes will be made automatically to DB after publishing the Data Store. But deletion of a column need to be done manually from DB. 
Even if you have removed it from CDT and published the Data Store , it won't automatically delete the column from DB. This need to be done manually. 
Thanks, 
Arati M

krishnau3863 · Answer

Hi vamsir, 
 
 You have to manually delete the columns in the DB, There is no other option.In your case as you did the mapping will be removed but columns will be there.