what is difference between "Primary key" and "Unique key"?

Answer Posted / satya_k21

Hi,

Primary Key: Not Null+ unique.but it wont allows null
values.

Unique: It allows null values , but it should be unique.

Regards,
Satya.k

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which kind of parameters cannot have a default value in pl sql?

805


what is 'mysqlshow'? : Sql dba

748


How many joins can you have in sql?

687


How to display the records between two range in Oracle SQL Plus?

870


What are sql built in functions?

677






explain advantages of myisam over innodb? : Sql dba

802


What is delete command in sql?

760


How do you take the union of two tables in sql?

731


Which table is left in left join?

715


How many types of cursors supported in pl/sql?

794


What is equi join in sql?

798


can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba

767


write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba

726


What are different types of functions in sql?

723


Can we join tables without foreign key?

693