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
What is set transaction?
What is sql*loader and what is it used for?
Does sql profiler affect performance?
What is compiled query?
What is the usage of the distinct keyword?
what are null values? : Sql dba
What are the set operators in sql?
what are wild cards used in database for pattern matching ? : Sql dba
What is varchar example?
What are all types of user defined functions?
How to run pl sql program in mysql?
How to get unique records from a table?
How to write html code in pl sql?
What are the different types of dbmss?
What is primary key secondary key alternate key candidate key?