在BCB中使用SQL建表时出现的问题，请高手帮忙解决！谢谢

[xzJohn]

为什么我使用下列语句建表
Query1->SQL->Text = "pclc INTEGER defaule 0,khlc INTEGER defaule 0,jblc INTEGER defaule 0,yslcp INTEGER defaule 0";
Query1->ExecSQL();
为何新建的表中字段没有缺省值。

[ken_henderson]

g z

[invalid]

看看我用SQLServer2000生成的SQL脚本：
参考一下吧；


CREATE TABLE [dbo].[lixi2] (
[lixiid] [bigint] IDENTITY (1, 1) NOT NULL ,
[acct] [char] (21) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[jgh] [char] (3) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[bankname] [varchar] (34) COLLATE Chinese_PRC_CI_AS NULL ,
[date1] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[page] [char] (5) COLLATE Chinese_PRC_CI_AS NULL ,
[hm] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[lixi] [char] (21) COLLATE Chinese_PRC_CI_AS NULL ,
[faxi] [char] (21) COLLATE Chinese_PRC_CI_AS NULL ,
[zy] [char] (80) COLLATE Chinese_PRC_CI_AS NULL ,
[jxdate] [char] (25) COLLATE Chinese_PRC_CI_AS NULL ,
[jishu] [char] (21) COLLATE Chinese_PRC_CI_AS NULL ,
[dqll] [char] (11) COLLATE Chinese_PRC_CI_AS NULL ,
[lixi2] [char] (21) COLLATE Chinese_PRC_CI_AS NULL ,
[cpth] [char] (8) COLLATE Chinese_PRC_CI_AS NULL ,
[dybz] [char] (8) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[ext] [char] (3) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[batchid] [bigint] NOT NULL
) ON [PRIMARY]
ALTER TABLE [dbo].[lixi2] WITH NOCHECK ADD
CONSTRAINT [DF_lixi2_bankname] DEFAULT ('山东省分行') FOR [bankname],
CONSTRAINT [DF_lixi2_dybz] DEFAULT (99999999) FOR [dybz]