◄Summary►  ◄Details►  ◄Example►                ◄Contents►  ◄Index►  ◄Back►
──────────────────────────────────────────────────────────────────────────────
                 ISAM available in Professional Edition only
──────────────────────────────────────────────────────────────────────────────
 Creates an index consisting of one or more columns of an ISAM table.
 Requires PROISAM.EXE or PROISAMD.EXE in the programming environment
 (VBDOS.EXE).
 
    CREATEINDEX [#]filenumber%,indexname$,unique%,columnname$[,columnname$]
 
    ■ filenumber%    Number used in the OPEN statement to open the table;
                     integer expression with a value between 1 and 255,
                     inclusive
 
    ■ indexname$     Valid table index
 
    ■ unique%        Nonzero value indicates a unique index
 
    ■ columnname$    Valid table column name
 
 See Also
    ◄DELETEINDEX Statement►            ◄GETINDEX$ Function►
    ◄ISAM Database Development►        ◄PROISAM Command-Line Options►
    ◄PROISAMD Command-Line Options►    ◄SETINDEX Statement►