Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between UNIQUE KEY and UNIQUE INDEX?
- 3 Answers
- 8881 Views
- TCS, I also Faced
- E-Mail Answers
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 having clause is used in sql?
Is primary key clustered or nonclustered?
what are different types of collation sensitivity? : Sql dba
What is a relationship and what are they?
Can we create a trigger on view?
how to shutdown mysql server? : Sql dba
How do you explain an index?
What is the basic structure of an sql?
What is mutating sql table?
how to write date and time literals? : Sql dba
what is the syntax for using sql_variant_property? : Transact sql
Why stored procedure is better than query?
mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql
What are the string functions in sql?
What is pl sql block structure?
