SQL Primitive Types
Boolean
| Type Name | Precision |
|---|---|
BOOLEAN |
1 |
BIT |
1 |
Numeric
| Type Name | Precision | Scale |
|---|---|---|
TINYINT |
3 | 0 |
SMALLINT |
5 | 0 |
INTEGER, INT |
10 | 0 |
BIGINT |
19 | 0 |
FLOAT, REAL |
8 | var |
DOUBLE |
16 | var |
NUMERIC |
Infinite | 2^92 |
Character
Binary
Date / Time
Intervals
##