If we declare constraints Unique and Not null on a single
column then it will act as a Primary key, so what is the use
of primary key??

Answer Posted / ashok

Internally , There is same as primary key and unique not null.
You can say unique + not null is higher step of primary key .
So there is no basic difference between this two.

Is This Answer Correct ?    7 Yes 11 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is set transaction?

678


What is sql*loader and what is it used for?

670


Does sql profiler affect performance?

638


What is compiled query?

639


What is the usage of the distinct keyword?

794






what are null values? : Sql dba

626


What are the set operators in sql?

665


what are wild cards used in database for pattern matching ? : Sql dba

656


What is varchar example?

662


What are all types of user defined functions?

615


How to run pl sql program in mysql?

594


How to get unique records from a table?

600


How to write html code in pl sql?

687


What are the different types of dbmss?

648


What is primary key secondary key alternate key candidate key?

652