CREATE TABLE [dbo].[Menu](
[MenuID] [varchar](20) COLLATE Chinese_PRC_CI_AS NOT NULL,
[MenuName] [varchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL,
CONSTRAINT [PK_Menu1] PRIMARY KEY CLUSTERED
(
[MenuID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

为什么执行时会出现这个错误
Msg 170, Level 15, State 1, Line 7
Line 7: Incorrect syntax near '('.
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]这一句有错

IGNORE_DUP_KEY = OFF can be used only in Create Index query

In this situation, please use the query below

CREATE TABLE [dbo].[Menu](
[MenuID] [varchar](20) COLLATE Chinese_PRC_CI_AS NOT NULL,
[MenuName] [varchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL,
CONSTRAINT [PK_Menu1] PRIMARY KEY CLUSTERED ([MenuID] ASC) ON [PRIMARY]
) ON [PRIMARY]

why IGNORE_DUP_KEY = OFF can be only used in Create Index query?
how to distinguish Index query or not Index query ?

No more reasons but only the request of syntax

You can find the explanation in the Books Online in details