title: how to auto increment primary key in visual studio built in sql server?
body: <p>I am using Visual Studio 2010 premium, and I created a database by using Visual Studio database tool. I set a field as primary key and I want to make it auto incremented. </p>
  
  <p>But when I look at the properties it is not active. I mean I cannot set using the Visual Studio 2010 premium built in database tool. I cannot set the identity specifications. Is it because I'm using Visual Studio 2010 premium? How can I make the productID column auto increment?   </p>
  
  <p><img src="https://i.stack.imgur.com/pptUa.png" alt="enter image description here"></p>