Quadcap Software

Quadcap Embeddable Database

Quadcap Software

Syntax

createIndexStmt
  :  "create" 
    (  "unique" 
    |  
    ) 
    "index" sqlId "on" sqlId LPAREN idList RPAREN 
  ;

Examples

CREATE UNIQUE INDEX STAFF_NAME ON STAFF(EMPNAME);
CREATE        INDEX WORKS_HOURS ON WORKS(HOURS);