开发者

what is the difference between UNIQUE INDEX and UNIQUE KEY?

开发者 https://www.devze.com 2023-01-07 07:01 出处:网络
I have seen couple of sampl开发者_高级运维e tables one is with UNIQUE INDEX and other is with 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

精彩评论

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