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?
我看过几个样本表，一个是UNIQUE INDEX，另一个是UNIQUE KEY。两个有什么区别？或者两者都一样？
1 个解决方案
#1
12
CREATE TABLE
KEY is normally a synonym for INDEX.
CREATE TABLE KEY通常是INDEX的同义词。
You can use them interchangeably as described in syntax page
[CONSTRAINT [symbol]] UNIQUE [INDEX|KEY]
您可以按语法页面[CONSTRAINT [symbol]] UNIQUE [INDEX | KEY]中的描述互换使用它们
#1
12
CREATE TABLE
KEY is normally a synonym for INDEX.
CREATE TABLE KEY通常是INDEX的同义词。
You can use them interchangeably as described in syntax page
[CONSTRAINT [symbol]] UNIQUE [INDEX|KEY]
您可以按语法页面[CONSTRAINT [symbol]] UNIQUE [INDEX | KEY]中的描述互换使用它们