Re: Is a primary key always desired?

"Odba1961" <odba1961_at_aol.com> wrote in message news:20031004093902.02137.00000391_at_mb-m01.aol.com...
> You are right, there are small lookup tables that do not require a primary
key.

Perhaps an example would help.

Create table us_states(
abbreviation char(2),
name varchar2(50));

insert into us_states values(null,'Arizona');
insert into us_states values('AZ','Arizona');
insert into us_states values('FL','Arizona');

commit;

Not much good really is it.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************