SSMS will gather up the changes to be executed as a single transaction. If you try to close the Table Designer before saving, a save prompt will allow you to choose “No” to discard the changes.

The View alert: Whoopi Goldberg is down. We repeat: Goldberg is — once again — down at the Hot Topics table.