What is the difference between UNIQUE KEY and UNIQUE INDEX?
Answer Posted / 1
There is a clear difference between the 2. A unique
constraint defines what combination of columns has to be
unique. A unique index is just a way of making sure the
above is always valid. But it's possible to have a non-
unique index supporting a unique constraint. (if the
constraint is deferable = Only has to be valid at commit
time but is allowed to be broken in the middle of a
transaction)
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Why select is used in sql?
What are properties of the transaction?
how to write date and time literals? : Sql dba
What are all the common sql functions?
What is the difference between left outer join and left join?
how to load data files into tables with 'mysqlimport'? : Sql dba
Is crud a cuss word?
What are all different types of collation sensitivity?
Is it possible to create the following trigger: before or after update trigger for each row?
Is primary key clustered or nonclustered?
How to fix oracle error ora-00942: table or view does not exist
Does a primary key have to be a number?
What are the 3 types of behavioral triggers?
What is a database trigger?
Why do you partition data?