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.
Previous Topic: ANY IDEAS WHY ?? I would really appreciate
Next Topic: Copying LONG datatype from one table to another
Goto Forum:
  


Current Time: Fri Oct 30 03:01:47 CDT 2020