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 sql used for?
Why we use joins in sql?
Is natural join same as inner join?
What is a common use of group by in sql?
What are crud methods?
How to use boolean type in select statement?
ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..
Explain the rollback statement?
What is trigger in sql and its types?
how to decrement dates by 1 in mysql? : Sql dba
how do you tune the slow running queries in oracle db , explain the methodology
What is sql architecture?
how to include numeric values in sql statements? : Sql dba
What is the sql case statement?
What are the indexing methods?