How to make a column Identity during design mode without having to always drill in to properties

• alan.fisher

  SSC-Addicted

  Points: 441

  More actions

  September 8, 2011 at 11:01 am

  #257027

  It seems like there must be an easier way to make a column an Identity field than the way I am doing it. I have to first make it an int then resize the Column Properties so I can see the Identity Specification then expand it so I can set it to

  True. Since this is a pretty common practice, using an Identity column for a primary key, I would think there would be a quicker way to get it done. Anybody have a hotkey workaround or something?

• sqltung

  Hall of Fame

  Points: 3962

  More actions

  September 8, 2011 at 11:34 am

  #1378801

  Only thing I can think of is to script it out. I sometimes find that scripting is faster and less of a pain than using the GUI.. sometimes!