sql 创建表

CREATE TABLE "Test" (
  "Id" INTEGER NOT NULL,
  "测试" TEXT,
  PRIMARY KEY ("Id")
);

转自:

https://www.cnblogs.com/orangeform/archive/2012/02/22/2325258.html

 

 

声明类型 亲缘类型 应用规则
INT
INTEGER
TINYINT
SMALLINT
MEDIUMINT
BIGINT
UNSIGNED BIG INT
INT2
INT8
INTEGER 1
CHARACTER(20)
VARCHAR(255)
VARYING CHARACTER(255)
NCHAR(55)
NATIVE CHARACTER(70)
NVARCHAR(100)
TEXT
CLOB
TEXT 2
BLOB NONE 3
REAL
DOUBLE
DOUBLE PRECISION
FLOAT
REAL 4
NUMERIC
DECIMAL(10,5)
BOOLEAN
DATE
DATETIME
NUMERIC 5
posted @ 2021-06-16 10:06  enych  阅读(41)  评论(0编辑  收藏  举报