what is the different between unique+not null & primary key,

Answer Posted / sreekumar

In a relation, we can create only one primary key where as we can create multiple unique+not null constrains.

Primary key uses clustered index where are unique +Not null uses non clustered index.

Sreekumar

Is This Answer Correct ?    18 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the advantages of sql?

823


How delete all records from table in sql?

766


How can triggers be used for the table auditing?

805


What is trigger in flip flop?

788


Which are the different types of indexes in sql?

809


Does sql support programming?

832


Is oracle and sql same?

778


What is difference between inner join and cross join?

763


What is user defined functions?

779


How do I view a view in sql?

736


Why is sql*loader direct path so fast?

849


What is the difference between between and in condition operators?

758


Do foreign keys improve performance?

788


What is the purpose of normalization?

820


how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

902