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 are the three pl sql block types?
What is the difference between Union and Union all. Which is faster.
What is graph sql?
How do you write an index?
How do I save a stored procedure?
What is difference between hql and sql?
Why we use pl sql?
What is information schema in sql?
List the different type of joins?
explain advantages of innodb over myisam. : Sql dba
How can you create an empty table from an existing table?
What does := mean in pl sql?
How delete all records from table in sql?
How does sql profiler work?
What are inbuilt functions in sql?