Is it better to have one Primary key even it is not usefull practilly?
4071Apr 6 2003 — edited Apr 10 2003Dear Members,
as i see in some documents do advise to have atleast one primary key for a table, some times i dont feel necessary to have a primary key like example below
T#1 comp_master
comp_code PRIMARY KEy,
comp_name
..
T#2 comp_phones
comp_code REFERENCES comp_master(comp_code),
emp_id REFERENCES emp(emp_id),
phone_number..
in the given scenario i dont see any usage of having primary key, is there any advantages to have a primary key may be sno NUMBER PRIMARY KEY, like that... in this typical scenario which one you advise.
Thanks in advance..