The datatype keyword specifies data types for table columns. Valid data types include the following:
| CHAR[n] | Fixed-length character string (default: n = 1) |
| VARCHAR[n] | Variable-length character string |
| DATETIME | Date and time (to the second) |
| DECIMAL(p[,s]) | Decimal of precision p, scale s |
| FLOAT | DECIMAL(8,6) |
| REAL | DECIMAL(8,6) |
| DOUBLE | DECIMAL(16,6) |
| INTEGER | Four-byte integer |
| SMALLINT | Two-byte integer |