programplug Logo



SQL Data Type

Data Types In SQL:


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)