What's the difference between a primary key and a unique
key?

Answer Posted / ramneet

There is one more diff b/w primary key and unique key that
there is only one primary key in a table but there are more
then one unique keys in a table.

Is This Answer Correct ?    11 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are different types of views?

561


can you instantiate a com object by using t-sql? : Sql server database administration

529


Explain acid?

625


What are the different types of subquery?

625


How use inner join in sql server?

623






How to write an inner join with the where clause in ms sql server?

563


Explain the third normal form(3nf)?

529


What is a Join and explain its types?

600


What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas

711


Explain what is the difference between union and union all?

562


How exceptions can be handled in sql server programming?

557


Can we write trigger for view?

571


What is the purpose of forms?

509


What is the difference between a function and a trigger?

581


What is a mutating table error and how can you get around it?

548