Interested to Buy Any Domain ? << Click Here >> for more details...
If we declare constraints Unique and Not null on a single
column then it will act as a Primary key, so what is the use
of primary key??
- 3 Answers
- 7387 Views
- I also Faced
- E-Mail Answers
Answer Posted / neha sinha
1) Primary key creates clustered index and unique key
creates non-clustered index. Performance wise clustered
index is fast so we need Primary key.
2)if we need more then one primary key in table than we can
use unique key+NOT NULL becous it behave as Primary key but
we cant define more than one column as primary key. :)
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is the difference between delete and truncate commands?
hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews
How many clustered indexes can you have?
what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba
Which is faster view or stored procedure?
how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba
Can we update views in sql?
what are the properties and different types of sub-queries? : Sql dba
What is the example of procedure?
How do you sort in sql?
How is sql used in oracle?
What is the purpose of the primary key?
what is top in tsql? : Transact sql
Explain aggregate functions are available there in sql?
Can we create a trigger on view?
