Autonumber (1 Viewer)

[trackdaychamp]

Hi,

I am using SQL SERVER 2005 and its Management Studio to manage my data. The tables in SQL have been linked in from Access but the Autonumbers have not persisted in SQL. The column type is listed as int.

Within SQL how do I change the data type to the equivalent of Autonumber for my Primary Keys?

Thanks in advance for any suggestions,

Mark

 

[boblarson]

In SQL it is an INT set as Identity.

 

[trackdaychamp]

Thanks

Hi Bob,

Thanks for your help