求助SQL查询分析器的问题
先请看下面的代码:
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' 的索引。”错误提出。
请高手指点。