However, sql server 2008 management studio doesn't always allow this to happen. Luckily, there is something you can do about it.
When inside of SQL Server Management studio:
1. Go to Tools menu -> Click on Options
You will see the Options window appear.
It will look like this:
2. Click on the triangle next to "Designers" and then click on the "Table and Database Designers" section.
It should then look like this:
3. Uncheck the "Prevent saving changes that require table re-creation".
4. Click OK
You should now be able to save changes as long as the save doesn't take too long.
NOTE: If the table you are trying to save changes too has alot of data in it, you may want to change the "Command Timeout" to not timeout after 30 seconds.
