先请看下面的代码:

if exists (select * from sysobjects where id = OBJECT_ID('[OA_GDZC_PJ]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) DROP TABLE [OA_GDZC_PJ]

CREATE TABLE [OA_GDZC_PJ] ( [GZXH] [int] NOT NULL , [PJXH] [int] NOT NULL , [MC] [nvarchar] (50) NULL , [GMRQ] [nvarchar] (10) NULL , [GGXH] [nvarchar] (50) NULL , [SL] [smallmoney] NULL , [GHF] [nvarchar] (100) NULL , [BZ] [nvarchar] (255) NULL )

ALTER TABLE [OA_GDZC_PJ] WITH NOCHECK ADD CONSTRAINT [PK_OA_GDZC_PJ] PRIMARY KEY NONCLUSTERED ( [GZXH] )

CREATE UNIQUE CLUSTERED INDEX [PK_OA_GDZC_PJ] ON [OA_GDZC_PJ] ( [PJXH] )

这段代码是想通过SQL查询分析器,生成一个OA_GDZC_PJ表,其中GZXH、PJXH都设置为主键，可是在执行SQL分析器时，将出现 “表 'OA_GDZC_PJ' 已有一个名为 'PK_OA_GDZC_PJ' 的索引。”错误提出。

请高手指点。

ALTER TABLE [OA_GDZC_PJ] WITH NOCHECK ADD CONSTRAINT [PK_OA_GDZC_PJ] PRIMARY KEY NONCLUSTERED ( [GZXH] )

CREATE UNIQUE CLUSTERED INDEX [PK_OA_GDZC_PJ] ON [OA_GDZC_PJ] ( [PJXH] )

这两行都创建了一个名为 PK_OA_GDZC_PJ 的索引呀,当然第二次就会出错了