Last post Jan 31, 2011 12:58 PM by EzzBoy
Jan 31, 2011 12:16 PM|EzzBoy|LINK
I tried all that was suggested in the above link..but I just cannot see the Identity data type option in the drop down. How can I set one field as a Identity data type if I dont see it?
Jan 31, 2011 12:40 PM|grundebar|LINK
Sql Server has an Identity specification but not as a data type. Typically, you set the column data type to int and then set the identity property to true for the column. This is easy to do through management studio. Click on the column and in the column
properties window expand the identity specification property. Change Is Identity to Yes and set your incremental options as desired.
Jan 31, 2011 12:43 PM|AceCorban|LINK
It is not a datatype, it is a property. So you won't find it in the drop down where you select int, varchar, etc.
If you are using Sql Management Studio, go to the "design" screen (or "modify", depending on your version) for the table you wish to declare an identity. When you select a specific column, you have a couple options like datatype and allow nulls. Below,
you should see "column properties". This is where you can find identity specifications. Expand it (if your version requires you to do so) and set the "Is Identity" property to "yes".
Jan 31, 2011 12:58 PM|EzzBoy|LINK