0 Replies Latest reply on Apr 19, 2004 12:33 PM by Adrian Wilford

    Hypersonic doesn't run well

    Adrian Wilford Newbie

      Hello!

      I need use a compound primary key. The script to create table is:

      -------------------------------------------------
      CREATE TABLE tablasalidas
      (matricula VARCHAR(10),
      horario VARCHAR(5),
      parada VARCHAR(20),
      PRIMARY KEY(matricula,horario)
      );
      -------------------------------------------------

      I think the script is correct, but Hypersonic creates normal primary key. What I have to do to create a compound primary key with Hypersonic?
      (If I use the HSQL DB Manager, in the "Indices" field I only see matricula as primary key)