本文介绍了操作失败,因为表“ Y”上已经存在名称为“ X”的索引或统计信息的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我是SQL的新手,我有一个SQL文件,执行该文件时会发生以下错误:

I am new to SQL and I have a SQL file and when I execute it the following error occurs:

运行此语句时发生错误:

The error occurs when running this statement:

CREATE UNIQUE NONCLUSTERED INDEX DDT_PK
    ON [DATE_DATA_TYPE]([TYPE_ID])
GO

ALTER TABLE [DATE_DATA_TYPE]
    ADD CONSTRAINT [DDT_PK] PRIMARY KEY ([TYPE_ID])
GO

我知道它已经存在,但是我想添加一个约束而不是再次创建索引,所以我在做什么

I know that it already exists but I want to add a constraint and not create the index again so what am I doing wrong?

也许您也必须知道表的创建方式,所以语句如下:

Maybe u have to know how the table was created too so here is the statement:

CREATE TABLE [DATE_DATA_TYPE] ([TYPE_ID] [numeric](18, 0) NOT NULL,
[TYPE_NAME] [varchar](400) NOT NULL, [UNIT] [varchar](32) NOT NULL,
[CHART_TYPE] [varchar](32) NOT NULL, [RES_ID] [numeric](18, 0) NOT NULL)
GO

我正在使用Microsoft SQL Server Management Studio。

I am using Microsoft SQL Server Management Studio.

推荐答案

主键自动为 INDEX 。如果要创建 NONCLUSTERED 主键,请使用:

A Primary Key is automatically an INDEX. If you want to create a NONCLUSTERED Primary Key then use:

ALTER TABLE [DATE_DATA_TYPE]
ADD CONSTRAINT [DDT_PK] PRIMARY KEY NONCLUSTERED ([TYPE_ID]);

这篇关于操作失败,因为表“ Y”上已经存在名称为“ X”的索引或统计信息的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

09-03 17:59