Is there a way to alter the design without creating table from scratch? [duplicate]

Question

I'm creating a database in SQL Server Management Studio which contains some tables plus stored procedures, now I have set all relationship between all tables but I want to alter something in the design of some tables however it keeps telling me the changing you have made require the following table to be dropped and re-created.

Is the a way do alter the design without creating table from scratch ??

Answer 1

Turn off this option here (under the Tools > Options menu in SSMS) and you'll be able to make your changes:

It's checked (and thus activated) by default after installation.