When you deploy your Sql Server code, there are two approaches, there is the manual way and the automated “compare & deploy” way.
Manual The manual way is where you track what changes you have made and when you want to release, build a script or set of scripts which contain the updates. If you are modifying objects then you should use alter or drop/create and you need to manually create rollback scripts (should you need them).