Delphi procedure to generate index create statement for access tables 1
Delphi procedure to generate index create statement for access tables
Version:
1
Price:
$100 (USD)
Platform:
Windows All Versions
SELECT * INTO EmMasterChanges IN "c:sched-v1datacarisch.mdb" FROM EmMasterChanges; CREATE INDEX PrimaryKey ON EmMasterChanges ([Number]) WITH PRIMARY ; The first statement is capable of importing structure and data from an auxillary database. The second statement modify creates index. The indexes are not included with the imported structure. Write a simple procedure, no interface for user 25 lines of code or less ... to scan a table and create a text line like: CREATE INDEX PrimaryKey ON EmMasterChanges ([Number]) WITH PRIMARY ; for each of the indexes in the access table?
Delphi procedure to generate index create statement for access tables Related Software: