When we can declare a column as Unique and Not Null both at
the same time. What is the use pf Primary Key then?
- 2 Answers
- 16566 Views
- Accenture, Unisoft Infotech, I also Faced
- E-Mail Answers
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 the difference between alter trigger and drop trigger statements?
Is it possible to link two groups inside a cross products after the cross products group has been created?
what are the authentication modes in sql server? How can it be changed? : Sql dba
What are synonyms in sql?
How do you modify a table in sql?
What is the difference between sql and t sql?
What can sql server reporting services do?
Which table is left in left join?
Name three sql operations that perform a sort.
Show the cursor attributes of pl/sql.
When do we use triggers?
Describe different types of general function used in sql?
How do temporal tables work?
What is pivot table in sql?
Is sql the best database?
