Re: !! URGENT - need Help !!

From: Jerry Gitomer <jgitomer_at_ictgroup.com>
Date: Tue, 13 Oct 1998 08:27:06 -0400
Message-ID: <6vvgrf$3og$1@client3.news.psi.net>

Hi Mathias,

If you can run on a PC client download a copy of T.O.A.D. from www.toadsoft.com

One of its many features is the ability to display the indexes for a table using it point and click interface. I have found T.O.A.D. to be a very valuable tool and am sure that you too will find it valuable.

regards

Jerry

Mathias Dehm wrote in message
<6vos23$1aam$1_at_grapool30.rz.uni-frankfurt.de>...
>Hey Martinj,
>
>thanx for fast answering.
>
>martinj (replace this with @) xs4all.nl wrote:
>>delete from my_table my
>>where my.rowid <
>>(select my2.rowid
>> from my_table my2
>> where my2.primary_key_field = my.primary_key_field
>>)
>
>
>For your solution i have to know the primary key fields to build the
>statemant. The build of the primary keys are coded in the application. So
i
>dont know the field names of the pk :-(
>
>I have this problem with more than 800 tables. I have to write a little
>programm to generate am complete scrpit for repairing the tables.
>
>
Received on Tue Oct 13 1998 - 07:27:06 CDT