专家坐堂-关于s ql数据表后台设计有默认值，foxtable新增后没有默认值了Foxtable(狐表) - 新一代数据库软件，完美融合Access、Foxpro、Excel、vb.net之优势，人人都能掌握的快速软件开发工具!

CREATE TABLE [dbo].[T_产品表] (

[产品ID] int IDENTITY(101,1) NOT NULL,

[产品名称] varchar(20) COLLATE Chinese_PRC_CI_AS NULL,

[产品类别ID] int NULL,

[产品码] smallint NULL,

[状态ID] smallint DEFAULT 1 NULL,

[产品类ID] smallint DEFAULT 1 NULL,

[产品级ID] smallint DEFAULT 1 NULL,

CONSTRAINT [PK_T_产品] PRIMARY KEY CLUSTERED ([产品ID])

WITH (PAD_INDEX = OFF, FILLFACTOR = 90, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)

ON [PRIMARY]

)

ON [PRIMARY]

ALTER TABLE [dbo].[T_产品表] SET (LOCK_ESCALATION = TABLE)