At 01:32 PM 25-09-01 +1200, you wrote:

>I have a situation where I delete all records in a table and then I
>drop the index on that table.
>The sql is
>
>delete from Table;
>drop index Table_Index;
>
>but because I have done delete before dropping the index the index
>is in use and I cannot drop it. How do I get around it.

Did you commit the deletes before trying to drop the index?

Helen

>Thanx
>
>Sandeep
>
>Software Developer
>CFL
>sandeep@...
>http://www.cfl.co.nz
>
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________