Subject Re: [firebird-support] How can I check to see if a table is corrupted?
Author Thomas Steinmaurer
> I have a table that appears to be corrupted because any SQL I run against it just runs. The table has a little over 976,000 rows. I can't drop or delete from the table. Is there a way I can either force drop the table or repair it?

You can't drop a table when it's being in use by concurrent requests,
which haven't been committed.

> I do have the data to rebuild the table.
>
> Thank you very much for your help.

If you are on >= 2.1, then go into the monitor tables and investigate
what statement is accessing your table. Perhaps a long-runner.

Thomas