开发者

what is the difference between UNIQUE INDEX and UNIQUE KEY?

I have seen couple of sampl开发者_高级运维e tables one is with UNIQUE INDEX and other is with UNIQUE KEY. what is the difference between two?? or both are same?


CREATE TABLE
KEY is normally a synonym for INDEX.

You can use them interchangeably as described in syntax page
[CONSTRAINT [symbol]] UNIQUE [INDEX|KEY]

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜