Cusotm DB table deletion from DEV QA and PRD

I need to delete a custom DB table in DEV and move the change further to QA and PRD with transport , will the transport automatically delete the existing data and table in QA and PRD or do we need any manual activity further ?

I was told that deletion of the table should be done through transport only in all 3 environment .

I have searched a lot but could not find the answer in SCN . Since it is very critical to delete any table and I have not done it before so need some suggestion Please .

Kindly let me know incase more detail required from myside .