CREATEINDEX Statement
◄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►