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) |