Re: DDL's - tables and keys

[Jeff Crosby <jlcrosby@xxxxxxxxxxxxxxxx>]

You can have a composite primary key on a table, as long as the composite
key remains unique, IE, no duplicate keys, as the primary key must be
unique.

If duplicate keys are required, then it must be an index.


On Tue, Oct 20, 2009 at 10:10 AM, Doug Palme <DPalme@xxxxxxxxxxx> wrote:

> In looking at the manual it appears that the only option I have for adding
> a key is the primary key, at least at the table level.  If I want to use
> more than one field I still have to create an index.
>
> Since we still have some programmers using tables and indexes as if they
> were PF's and LF's, I am trying to ascertain if there is any way to add a
> composite primary key to a table without an index?
>
> I assume no from what I have read thus far......but if anyone knows of a
> way or can offer clarification I would be most appreciative.
>
> Douglas
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.