|
|
|
Data type in sql defines a set of value that a coloumn can contain. In database table, each coloumn is required to have a data type with a specified name.
| Data type | Syntax |
|---|---|
| Integar | INTEGAR |
| Real | REAL |
| Smallint | SMALLINT |
| Decimal | DECIMAL(P,S) |
| Float | FLOAT(P) |
| Character | CHAR(X) |
| Numeric | NUMERIC(P,S) |
| Date | DATE |
| Time | TIME |
| Timestamp | TIMESTAMP |
| Bit | BIT(X) |