When we can declare a column as Unique and Not Null both at
the same time. What is the use pf Primary Key then?
Answer Posted / swapna
The concept of adding an unique key and not null constraint
to a column as well as adding as unique index to it , you
will assume to get the benefits of adding an primary key
to that column.
But use it for the purpose of referential integrity will
not allow to do so.
That's what PK is so useful. You will use it for
normalization purpose.
Is This Answer Correct ? | 12 Yes | 6 No |
Post New Answer View All Answers
What is pivot in sql?
What is trigger types in sql?
Can a table contain multiple foreign key’s?
What is oracle pl sql developer?
What is rename command in sql?
What is a sql profiler?
What is the purpose of using pl/sql?
What is database migration?
what is 'mysqlshow'? : Sql dba
Which are sql * plus commands?
What is string join?
What is the use of %rowtype?
Why we use pl sql?
What happens when a trigger is associated to a view?
Can we use join in subquery?