| Primary Key [message #7852] |
Sat, 12 July 2003 08:05  |
Galvano
Messages: 3
Registered: July 2003
|
Junior Member |
|
|
Hi ! I'm migrating Db2 Tables to Oracle 8.1.7.4
Db2 Tables don't have primary keys and not refential
integrity, but only unique indexes.
Is it always better to define primary key on Oracle
Tables ?
Thank you
Galvano
Italy
|
|
|
|
| Re: Primary Key [message #7868 is a reply to message #7852] |
Mon, 14 July 2003 03:01  |
Nalaneelan
Messages: 12
Registered: June 2003
|
Junior Member |
|
|
Galvano,
It depends upon the column how u r going to use it.
1. If the column is NOT going to have Null values and only it is going to contain Unique ones, then go for Primary key.
2. If it does has Null and unique values, go for Unique key.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
