An integer is a whole number. It may be positive or negative, depending on its use, but cannot have a fractional part. SQL uses integers in many situations. For example, you specify an integer to refer to columns by column number.