Local SQL - Create Index - Create Non-Maintained?

Mike

Delphi Developer

Sat, 20 Apr 2002 03:00:00 GMT

Local SQL - Create Index - Create Non-Maintained?

Hello all.

I have a sql statement that creates an index on a local paradox table.

create index byMasterList on ItemMast
(DepartmentNumber,ItemSequenceNumber,ItemNumber)

However, it creates a maintained index. How can I create a Non Maintained
Index using SQL?

Thanks,
Mike

Bill Tod

Delphi Developer

Sat, 20 Apr 2002 03:00:00 GMT

Re:Local SQL - Create Index - Create Non-Maintained?

You cannot and I can't imagine why you would want to. Non-maintained indices
are a leftover from Paradox for DOS 1.0 and there is no reason to use them.

Bill
--
Bill Todd (TeamB)
(TeamB cannot respond to questions received via email)

Other Threads

1. Creating non-maintained Indexes from delphi3

2. Creating dbase expression Indices with Local SQL

3. Help: Creating Indexes in Local SQL

4. Local SQL - CREATE INDEX problem

5. Can't create primary index in local sql

6. How do I create a maintained index?

7. Non-maintained indices in a multi-user environment

8. Non-maintained indices in a multi-user environment

9. Creating NONMAINTAINED index (*.ndx) FOR DBASE

10. Creating an non-primary Index