Download SQL Quick Syntax Guide

Transcript
Data Type
Data Type
CHAR
(
CHARACTER
)
size
(1)
GLS
NCHAR
+
+
DATE
+
DATETIME
DATETIME Field Qualifier p. 95
DECIMAL
(
DEC
)
precision
NUMERIC
, scale
16
FLOAT
(
float
precision
)
DOUBLE PRECISION
INTEGER
INT
+
INTERVAL
+
MONEY
INTERVAL Field Qualifier p. 105
(
)
precision
16
,2
, scale
SERIAL
+
(
+
(1)
start
)
SMALLFLOAT
REAL
SMALLINT
OL
94
SQL Quick Syntax Guide
INFORMIX-OnLine Dynamic Server-Specific Data Types p. 95