Thread: compound key

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

On Fri, 19 Mar 1999, MESZAROS Attila wrote:

> 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 ?

CREATE UNIQUE INDEX AttributeNames_pkey
ON AttributeNames(id, classId);

Or even

create table AttributeNames (
    id           integer not null,
    name         varchar(200),
    classId      integer not null
    PRIMARY KEY(id, classId);
 );

Brett W. McCoy
                                         http://www.lan2wan.com/~bmccoy
-----------------------------------------------------------------------
Labor, n.:
    One of the processes by which A acquires property for B.
        -- Ambrose Bierce, "The Devil's Dictionary"

----- BEGIN GEEK CODE BLOCK -----
Version: 3.12
GAT dpu s:-- a C++++ UL++++$ P+ L+++ E W++ N- o K- w--- O@ M-@ !V PS+++
PE Y+ PGP- t++ 5- X+ R+@ tv b+++ DI+++ D+ e>++ h+ r++ y++++
------ END GEEK CODE BLOCK ------