Short Auto-Number field

[bradleyhorn]

Hi All,

In some tables brought over from Access into SQL-Server I have some auto number fields. They were brought into SQL-Server with a datatype of Int, length of 4, precision of 10. Since the length is 4 does this mean that there are only 10,000 possible values for this auto number field? Should I change datatype if I expect more than 10,000 entries in this table? To change the lenth of this auto-number field it seems to want me to change the datatype. Should I change it to numeric? Will the idendity property be supported by the numeric datatype?

Bradley

 

[payback]

From the SQL Server Books On-Line (which should install with SQL Server) -

int

Integer (whole number) data from -2^31 (-2,147,483,648) through 2^31 - 1 (2,147,483,647). Storage size is 4 bytes. The SQL-92 synonym for int is integer.

 

[bradleyhorn]

Thanks for the clarification. Much appreciated.