Re: [SQL] compound key

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