UNIQUE INDEX和UNIQUE KEY有什么区别? [英] what is the difference between UNIQUE INDEX and UNIQUE KEY?
本文介绍了UNIQUE INDEX和UNIQUE KEY有什么区别?的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我已经看到了几个示例表，一个是UNIQUE INDEX，另一个是UNIQUE KEY. 两者有什么区别?还是两者相同?
I have seen couple of sample 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.
您可以按照语法页中的说明互换使用它们
[CONSTRAINT [symbol]] UNIQUE [INDEX | KEY]
You can use them interchangeably as described in syntax page
[CONSTRAINT [symbol]] UNIQUE [INDEX|KEY]
这篇关于UNIQUE INDEX和UNIQUE KEY有什么区别?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
