Primary Key

Hi All,

Is there any way to make the "Primary Key" generate itself? I think in an
Acess database there is an option so that whenever you enter a new line it automatically generates a Unique Primary Key. I don't see how to do this in a SQL Server Database? Perhaps I just missed it. This is new to me.Or is there some VB code that will make a unique key whenever a new line of data is entered. Thanks in Advance.

Nick
[444 byte] By [NV2002] at [2007-11-20 11:30:10]
# 1 Re: Primary Key
See the 'Identity' property for the column in question (or the table.) The column must be an int for it to work, and there can only be one Identity column.
andreasblixt at 2007-11-9 13:45:38 >
# 2 Re: Primary Key
Thanks so much :) . I was looking all over and could not figure that out.
I just tried it and it works.
NV2002 at 2007-11-9 13:46:38 >