yeah, I've been trying a couple things like your suggestions but since I'm
looking to drop primary, foreign, and indexed indexes I had to create two
views, one with 'alter table drop constrain' order by sys_primary_key and
another for my 'drop index' and wrote them out to a file. Worked pretty but
when I ran my file I couldn't get threw it all till I got an 'Access
violation error..' and it put a table lock on the last table 'altered'. So
I'm off to plan B...thanks for the assistance.
----- Original Message -----
From: "James Bentley" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Thursday, April 24, 2008 11:27 AM
Subject: [RBASE-L] - Re: Droping a databases Indexes
Rachael,
No quick command to drop all indexes. Try the following command
file to create another command file to DROP the indexes.
SET HEADINGS OFF
OUTPUT DRPIDX.RMD
WRITE '-- Drop of all indexes'
SELECT DISTINCT ('DROP INDEX
`'+sys_index_name+'`--'+sys_table_name)=60 +
FROM sys_indexes t1 INNER +
JOIN sys_tables t2 ON t1.sys_table_id=t2.sys_table_id +
WHERE t2.sys_table_type='TABLE' AND (0=(t1.sys_primary_key++
t1.sys_unique_index+t1.sys_foreign_key+t1.sys_dbf_idx))
OUTPUT SCREEN
SET HEADINGS ON
RETURN
-- I suggest you first do "RBEDIT DRPIDX.RMD" to check out that
you
-- have created commands to drop the proper indexes.
-- you would then "RUN DRPIDX.RMD" to delete the indexes
If you cut and paste my code be sure that each line is properly
continued as the email program my have split it at inappropriate
places.
Jim Bentley
--- Rachael Malberg <[EMAIL PROTECTED]> wrote:
is there a quick way to drop all db indexes?
Jim Bentley
American Celiac Society
[EMAIL PROTECTED]
tel: 1-504-737-3293
____________________________________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now.
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
