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?

I do have the data to rebuild the table.

Thank you very much for your help.