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 is the Control Flow in SSIS

582


what are the three command line utilities and what are their primary functions?

103


explain different types of constraints? : Sql server database administration

521


How to transfer an existing table from one schema to another schema in ms sql server?

519


What are date and time data types in ms sql server?

537






Explain what is lock escalation?

588


What is temporal table?

492


Write a SQL queries on Self Join and Inner Join.

623


How can you list all the table constraints in a database?

520


Define tool Manage Statistics in SQL Server 2000 query ?

531


Which sql server table is used to hold the stored procedure scripts?

624


What is scheduled job and how to create it?

556


Tell me what is de-normalization and what are some of the examples of it?

580


What is the default schema of your login session in ms sql server?

600


what are constraints? : Sql server database administration

545