每个表中的列名必须是唯一的 - 创建列标识 [英] Column Names in each table must me unique - making a column identity

问题描述

您好，出于某种原因，当我尝试将列设置为标识时，它会给出错误，即列名必须是唯一的。我知道这应该是什么意思，但问题是我没有重复的列。此外，我试图让其他列的标识只是为了测试它，它不适用于我的表中的任何列。有没有人遇到过这个问题？

Hello, for some reason when I try to make a column an identity it gives me the error that column names must be unique. I know what this is supposed to mean, but the problem is that I don't have duplicate columns. Also, I tried to make other columns the identity just to test it out and it doesn't work on any column in my table. Has anyone ever ran into this problem?

推荐答案

如果您的表中有数据，那么在更改该表之前，您必须确保数据是唯一的且没有重复数据，错误可能是指那个，而不是列名。

If you have data in your table then you have to make sure that the data is unique and without duplicates before altering that table, the error is probably referring to that and not the column name.

这篇关于每个表中的列名必须是唯一的 - 创建列标识的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！