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 triggers associated with image items?
What is union?
What is the use of sqldataadapter?
what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql
how to rename an existing column in a table? : Sql dba
Why truncate is faster than delete?
How long will it take to learn pl sql?
What is the command used to fetch the first 5 characters of a string?
Is not null in sql?
What is pl sql record in oracle?
What are functions in sql?
Are stored procedures faster than queries?
what is error ora-03113: end-of-file on communication channel?
What is trigger explain with example?
Does db2 use sql?