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]
GO
ALTER TABLE [dbo].[T_产品表] SET (LOCK_ESCALATION = TABLE)