Primary key int from 4 to 10 possible?

[ombina]

I appreciate you are reading this. I just realize that my Member table has a primary key only up to 9999. Duh! For some reaseon when I migrated it from Access that's how it came aboard.

Is it possible to increase from 4 to 10 length?

Thanks,

Ricky Thanks,

Ricky

 

[Transcend]

An int field with a length of 4 does NOT mean that the primary keys only go up to 9999. The length of four means the Storage size is 4 bytes.

Integer (whole number) data from -2^31 (-2,147,483,648) through 2^31 - 1 (2,147,483,647).

Transcend

 

[sguslan]

If the field type is Int then you will be OK for up to 2,147,483,647. If you need to store values that are more than that, then use BigInt , Numeric(10,0) or Decimal(10,0) ... ________________________________________________________________________________
If you do not like change, get out of the IT business...

 

[ombina]

Thank you so much both. I guess I need to learn more of this stuff.

Thanks,

Ricky Thanks,

Ricky