Home » RDBMS Server » Server Administration » difference in primary key vs unique+not null
difference in primary key vs unique+not null [message #370416] Wed, 22 September 1999 15:08
atul
Messages: 17
Registered: September 1999
Junior Member
Pls let me know the difference :

if two tables having same 2 fields
suppose emp_no number(3)
emp_name varchar2(30)

in one table I take emp_no as a primary key

and in other table I take emp_no as a Unique+not null

Thanks.

Report message to a moderator

Previous Topic: ANY IDEAS WHY ?? I would really appreciate
Next Topic: Copying LONG datatype from one table to another
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Mar 12 07:07:02 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.