Query on Primary key

sreenigacc · New User Joined: 16 Oct 2007 Posts: 15 Location: bangalore

Hi,

I have a query on primary key. I have a table, which is having more than one primary key.

I mean there are 4 columns with primary key out of 76 columns in the table.

in that four columns any column can have the same data multiple times, but if we combine all these 4 columns then the data will be unique.

If it is the case, what we call this group of columns.

thanks in advance
sreenivasulu G

Gnanas N · Posted: Tue May 06, 2008 9:04 pm

Composite primary key!

guptae · Posted: Tue May 06, 2008 9:15 pm

Hello Sreeni,

Its known as COMPOSIT PRIMARY KEY.
please read the manual befor posting .