CREATE [TEMPORARY] TABLE表
(字段1类型 [(字长)] [NOT NULL] [WITH COMPRESSION | WITH COMP] [索引1] [, 字段2类型 [(字长)] [NOT NULL] [索引2] [, ...]] [, CONSTRAINT multifieldindex [, ...]]) |
关键词 | 描述 |
---|---|
Counter | 自动编号 |
Memo | 备注 |
Real | 单精度浮点 |
Float | 双精度浮点 |
Varchar | 文本,最大255 |
Create table test(id Counter primary key, num Float, [memo] Memo) |