1> create table GOODS ( 2> GOODS_CODE CHAR(6) NOT NULL, 3> GOODS_NAME VARCHAR(20) NULL, 4> TANKA DECIMAL(10,2) NULL, 5> LOT INT NULL, 6> YOSAN MONEY NULL, 7> 更新日 DATETIME NULL 8> ) 9> go 1> select * from goods 2> go