U890升级U811.1Sql Server数据库报错

ComingHope

数据库名: UFDATA_001_2010
D:\U8SOFT\Admin\SQLFILE10000\Main\Ufdata\Structure\Data_PRV_GL_mix_NL.sql
错误信息:
-2147217900
表 'gl_mend' 已经有针对它定义的主键。

执行如下语句时出错:


IF  EXISTS (SELECT * FROM dbo.sysindexes WHERE id = OBJECT_ID(N'[dbo].[GL_mend]') AND name = N'GL_mend_PK')
ALTER TABLE [dbo].[GL_mend] DROP CONSTRAINT [GL_mend_PK]
alter table gl_mend add constraint gl_mend_pk PRIMARY KEY NONCLUSTERED
( iyear asc,
[iperiod] ASC
) ON [PRIMARY]

13264441063

既然已给了错误提示，建议删除数据库里的主键试一下呗