在CREATE INDEX语句中指定的选项无效 [英] Invalid option specified in CREATE INDEX statement

问题描述

我正在尝试使用SQLCE创建一个表，该表应忽略任何重复的值.为此，我想选择一个列作为索引并使用IGNORE_DUP_KEY选项.当我运行以下代码时:

I'm trying to create a table which should ignore any duplicate value, using SQLCE. To do this, I figured I would select a column to be the index and use the IGNORE_DUP_KEYoption. When I run the code below:

CREATE NONCLUSTERED INDEX url_index ON Person (url ASC) WITH (IGNORE_DUP_KEY=ON)

我收到一条错误消息，提示在CREATE INDEX语句中指定了无效的选项.[选项名称= IGNORE_DUP_KEY]."

I get an error message saying "Invalid option specified in CREATE INDEX statement. [option name = IGNORE_DUP_KEY]."

这是因为我正在使用SQLCE吗?如果是这样，我该如何忽略SQLCE中的重复项?

Is this because I'm using SQLCE? If so, how can I ignore duplicates in SQLCE?

推荐答案

查看全文