Can't create Integer field, a Long Integer is created instead?

[cbu]

Using VB6 to add a new field of type Integer with
following command text:
"ALTER table <table name> ADD COLUMN <New field name>
INT" ( also tried using "INTEGER instead of just 'INT'"

This always creates the new field as a LONG INTEGER and I
don't know why. I use "ALTER table <table name> ADD
COLUMN <New field name> LONG" to create a long integer
field, but I just want the size to be the smaller of the
two ('Integer' type).

How can this be done?

 

[JSand42737]

Using VB6 to add a new field of type Integer with
following command text:
"ALTER table <table name> ADD COLUMN <New field name>
INT" ( also tried using "INTEGER instead of just 'INT'"

This always creates the new field as a LONG INTEGER and I
don't know why. I use "ALTER table <table name> ADD
COLUMN <New field name> LONG" to create a long integer
field, but I just want the size to be the smaller of the
two ('Integer' type).

How can this be done?

You can use either SHORT, SMALLINT or INTEGER2.