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

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

  • Comments 0

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

Tools > Options

image

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

Namoskar!!!

Leave a Comment
  • Please add 5 and 5 and type the answer here:
  • Post