SQL Server Management Studio - Adding/Moving Columns require drop and re-create?

Viewed 38710

Why do I get message that the table needs to dropped and re-created when I add/move columns? I believe this happens after adding foreign key constraints.

What can I do to add new columns without dropping table?

5 Answers
Related