compound key

From: MESZAROS Attila <tilla(at)chiara(dot)csoma(dot)elte(dot)hu>
To: pgsql-sql(at)hub(dot)org
Subject: compound key
Date: 1999-03-19 20:58:36
Message-ID: Pine.LNX.3.96.990319214553.24189A-100000@chiara.csoma.elte.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,

I have seen the following stucture in AdabasD:
create table AttributeNames (
id integer not null,
name varchar(200),
classId integer not null
);
alter table AttributeNames add primary key (id,classId);

I know, I can't create "compound key" using "alter table", but is there
any way to create one ?

thanx,
Attila

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Ismail Kizir 1999-03-19 21:28:31
Previous Message David Martinez Cuevas 1999-03-19 16:22:13 Re: [SQL] Re: Stuck on SQL - Any Takers?