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
