COMPOSITE PRIMARY KEY?

[Seena Blace]

Hi,
I want to create a table with composite Primary key.How to do that?
create table ipdet
  (IPaddress  varchar (14) not null ,
   hostid  varchar (20) not null  primary key (ipaddress,hostid),
   IP_DESC  text ,
   MAC   text,
   interface text);
thx-seena


---------------------------------
Do you Yahoo!?
Yahoo! Finance: Get your refund fast by filing online