Database Driver; Data Type dialog box

Native type

Click the physical data type for the target DBMS to which the portable data type is mapped.

Length

Type the number of characters.

Precision

Type the total number of digits (the number of digits to the left of the decimal point plus the number of digits to the right of the decimal point).

Scale

For applicable data types, type the number of digits that appear after the decimal point.

Identity

Select this check box to indicate that the column contains system-generated values that uniquely identify each row within a table.

You can use this feature to generate sequential numbers (for example, employee IDs). When you insert values into a table that has an identity column, the database automatically generates the next identifier based on the last used identity value.