Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: primary keys
CREATE TABLE table_name(
last_name varchar2(20),
first_name varchar2(20)
CONSTRAINT table_name_pk_idx
PRIMARY KEY (last_name, first_name)
etc
"Herman" <landsaat_at_intekom.co.za> wrote in message
news:9rkcqf$fu$1_at_ctb-nnrp2.saix.net...
> HI there
>
> For most of you this is common knowledge but there is something I'd like
to
> know. I would like to make more than 1 column my primary key. If possible
> how is this done?
>
> T.y.
> Herman
>
>
Received on Mon Oct 29 2001 - 14:24:11 CST