In production, changes are made methodically using pre-tested scripts and scheduled to minimize downtime. But at least SSMS will help generate these powerful scripts for us.