Thread

1. compound key

   MESZAROS Attila <tilla@chiara.csoma.elte.hu> — 1999-03-19T20:58:36Z

   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
   
   
   

2. Re: [SQL] compound key

   Brett W. McCoy <bmccoy@lan2wan.com> — 1999-03-20T00:07:51Z

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