What is differance unique key and primary key.

Answer Posted / gourvendra singh

Unique : One or more unique key in a table,
allow only one null in the field.

Primary :Only one primary key in a table and u cannot
insert null into it.

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain ttitle and btitle.

672


Explain commit, rollback and savepoint.

605


Are views faster than queries?

548


how to dump a table to a file with 'mysqldump'? : Sql dba

555


What is the maximum database size for sql express?

538






Will truncate release space?

517


How delete all data from all tables in sql?

540


What is the difference between sum and count in sql?

528


Explain the select statement in sql?

616


what is self join and what is the requirement of self join? : Sql dba

683


Explain the uses of a database trigger?

571


Why is sql important?

580


what are rollup and cube in t-sql? : Transact sql

661


What are the usages of sql?

564


How do you explain an index number?

535