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
- 6745 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
Does view store data in sql?
Which join is like inner join?
what is the use of set statement in tsql? : Transact sql
What is mdb stand for?
What does 0 mean in sql?
How do you write a complex sql query?
What is mutating table error?
Which table is left in join?
What are tables in sql?
What is a function in oracle pl sql?
What is denormalization in a database?
how to enter binary numbers in sql statements? : Sql dba
What is cursor status?
Name three sql operations that perform a sort.
How to write a query to show the details of a student from students table whose
