Re: what is my error??

Chang your systax error lies in your constraint defination. It is actually backward. Try this: primary key (SID, NAME) constraint PK_ACTIVE_SESSIONS HTH Joe ------------------------------------------------------------------------- Joseph Cullipher <joseph@cannonexpress.com> Standard Disclaimers Apply ------------------------------------------------------------------------- On 11 May 1999, Chang-Woo Park wrote: > create table ACTIVE_SESSIONS > ( > SID varchar(32) not null, > NAME varchar(32) not null, > VAL text , > CHANGED varchar(14) not null, > constraint PK_ACTIVE_SESSIONS primary key (SID, NAME) > );>