Integer Field Type

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: Choose Data Types

How to: Set Autoincrementing Field Values

Concepts

Creating Numeric Expressions

Autoincrementing Field Values in Tables

Reference

CREATE TABLE - SQL Command

Numeric Operators

ALTER TABLE - SQL Command

CREATE TABLE - SQL Command

CREATE CURSOR - SQL Command

Other Resources

Data and Field Types