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
- 16950 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
How much ram can sql express use?
What are the constraints available in sql?
What is a data definition language?
How do I create a sql script?
what are the limitations of identity column? : Transact sql
Show code of a cursor for loop.
What is sqlerrm?
What is the difference between rollback and rollback to statements?
Can we use rowid as primary key?
Is null operator in sql?
give the syntax of grant and revoke commands? : Sql dba
What are properties of the transaction?
How to pronounce postgresql?
what are dynamic queries in t-sql? : Transact sql
What is the difference between explicit and implicit cursors in oracle?
