Wriju's BLOG

.NET, Cloud and everything

SQL Server 2008 R2 Management Studio designer was not allowing me to add primary key to a column of an empty table

What the heck!!! Then finally Amar did help me to get it done. Simple “option”. Life has too many “options”.

Tools > Options


You need to just uncheck the option “Prevent saving changes that require table re-creation”