Home » RDBMS Server » Server Administration » Primary Key
Primary Key [message #57728] Wed, 02 July 2003 12:54 Go to next message
Galvano
Messages: 3
Registered: July 2003
Junior Member
Hi ! I'm migrating db2 tables to oracle.
I'm not going to use referential integrity , but is it better to create a primary key on a table insted of only an unique index ?

Thank you

Galvano

Italy

Report message to a moderator

Re: Primary Key [message #57737 is a reply to message #57728] Wed, 02 July 2003 18:03 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
i beleive, primary key creates a unique index....?

Report message to a moderator

Re: Primary Key [message #57778 is a reply to message #57737] Mon, 07 July 2003 08:19 Go to previous message
Angelo
Messages: 16
Registered: November 2001
Junior Member
a NOT NULL unique index

Report message to a moderator

Previous Topic: Maximum number of services
Next Topic: Modify job
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 07:27:58 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.