Re: Primary key with two columns
From: Rene Nyffenegger <rene.nyffenegger_at_gmx.ch>
Date: 11 Jul 2002 03:09:48 -0700
Message-ID: <a6d06107.0207110209.f0dd_at_posting.google.com>
Date: 11 Jul 2002 03:09:48 -0700
Message-ID: <a6d06107.0207110209.f0dd_at_posting.google.com>
> I hope someone can help me with this:
>
> I want to cerate a table 'whatever' with columns
> c1 varchar2(10)
> c2 number(4)
> c3 varchar2(10)
> c4 date
create table whatever (
c1 varchar2(10),
c2 number(4),
c3 varchar2(10),
c4 date,
constraint pk_whatever primary key (c1,c2)
);
Hth,
Rene Received on Thu Jul 11 2002 - 12:09:48 CEST