I was having a lot of problems with a table for which none of the indexes were functioning, so I deleted it, yet it still appears in the PCC list of tables. I can no longer do a select statement on the table because it gives an error saying the table does not exist, but then when I try to create the table I get an error message saying the table already exists!

So how can I clear this table away for real such that I can create it again from scratch?
 

 If you deleted the underlying data file but didn't drop the table in the database, you'll need to issue a DROP TABLE <tablename> IN DICTIONARY.

The IN DICTIONARY tells the engine to only remove the entry from the database.