To store non-decimal numeric values when performance and table storage limitations are especially important, use the Integer field type. To generate values, such ID numbers, use Integer (Autoinc) that automatically increments the value.
In tables, the Integer field type is stored as a 4-byte binary value. As a result, it requires less memory than other Numeric data types. As a binary value, it requires no ASCII
For specifications about the Integer and Integer (Autoinc) field types, see Visual FoxPro Data and Field Types.
See Also
Tasks
How to: Set Autoincrementing Field ValuesReference
ALTER TABLE - SQL CommandCREATE TABLE - SQL Command
CREATE CURSOR - SQL Command
Concepts
Autoincrementing Field Values in TablesOther Resources
Data and Field TypesHow to: Choose Data Types
CREATE TABLE - SQL Command
Creating Numeric Expressions
Numeric Operators