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
Why use triggers in sql?
What is a stored procedure in sql with example?
how to concatenate two character strings? : Sql dba
How many developers work on postgresql?
What is the sql*loader? : aql loader
what is sql server agent? : Sql dba
What is difference between pls_integer and integer?
What is vector point function?
What are the differences between in and exists clause?
What is error ora-01000: maximum open cursors exceeded
how to include character strings in sql statements? : Sql dba
Which command is used to delete a package?
how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba
What is a primary key called that is made up of more than one field?
How can we implement rollback or commit statement in a trigger?