• If u r doing this through t-sql then no table drop will occur on the production environment but if u r doing this through ssms then it depends on the the script used to make changes.