Changing indexes in tables with relations

Changing indexes in tables with relations

Post by Micha3 Piaseck » Sun, 31 Dec 1899 09:00:00

        I've got problem with index. When I change index in my master, or detail
table realtion flies away. Even when I set back the index with which
relation was set reference does not comes back. I usually set relations in
TTABLE component.
         Now I wonder if it's possible to change index and not to loose the

Michal Piasecki


1. Deleting Table Index Keys and Relations

Using VB6 code, I create 25 tables with index keys and
relations. I have no problem creating the tables. But
there may be times when the user will want to abort the
application. I need to be able to delete all 25 tables.
But because of the index keys and relations, VB won't let
me delete the tables. I can't find text that describes how
to use code to remove the primary keys and relations so
that I can delete the tables. Can anyone help?

Thanks in advance - Ron

2. An error in docs? (client-only installation)

3. Relation between DROP TABLE and DROP INDEX

4. JSQL - anyone using it??

5. Relations between tables n:m-relation


7. Relations, Relation,s Relations 2.6

8. Changing Table Structure and Full text indexing

9. Changing the Primary Index of a Table.

10. Patches (current CVS) for changes if index AM tables

11. Changing index in Paradox-Tables

12. ALTER TABLE OWNER: change indexes