W
woker
Unregistered / Unconfirmed
GUEST, unregistred user!
用bold生成数据库表时,建库SQL自动给varchar类型加上“default”,而数据库不认此关键字,如何取消“dfault”?
例子:
CREATE TABLE Person ( BOLD_ID INTEGER NOT NULL, BOLD_TYPE SMALLINT NOT
NULL, Address1 VARCHAR(32) DEFAULT '' , Address2 VARCHAR(32) DEFAULT ''
, Address3 VARCHAR(32) DEFAULT '' , City VARCHAR(16) DEFAULT '' ,
DateOfBirth DATE , FirstName VARCHAR(16) DEFAULT '' , LastName
VARCHAR(16) DEFAULT '' , PostCode VARCHAR(16) DEFAULT '' , Title
VARCHAR(8) DEFAULT '' , CONSTRAINT IX_Person_BOLD_ID PRIMARY KEY (BOLD_ID))
例子:
CREATE TABLE Person ( BOLD_ID INTEGER NOT NULL, BOLD_TYPE SMALLINT NOT
NULL, Address1 VARCHAR(32) DEFAULT '' , Address2 VARCHAR(32) DEFAULT ''
, Address3 VARCHAR(32) DEFAULT '' , City VARCHAR(16) DEFAULT '' ,
DateOfBirth DATE , FirstName VARCHAR(16) DEFAULT '' , LastName
VARCHAR(16) DEFAULT '' , PostCode VARCHAR(16) DEFAULT '' , Title
VARCHAR(8) DEFAULT '' , CONSTRAINT IX_Person_BOLD_ID PRIMARY KEY (BOLD_ID))