what is difference between primary key and Unique

Answer Posted / navneet sharma

Unique key allow null value and it is a non cluster index
Primary key does not allow null value and it is custer index

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What number aggregate functions are accessible there in sql?

772


Explain transaction server implicit?

688


Define cross join in sql server joins?

750


How to make conditional sum in ssrs?

148


If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

719






What are number line correlation administrators will use while working with a subquery?

836


Can you please explain the difference between primary keys and foreign keys?

838


What are the different types of subquery?

815


What is the osql utility?

724


What are the different types of replication you can set up in sql server?

714


What is linked report?

104


What is the security principal at the server level that represents your session?

777


Describe in brief sql server monitoring ways.

752


Explain an incremental backup?

749


How raid can influence database performance?

753