When restoring from a backup I have some bad tables with corruption (can not say which error number right now as I am recovering). I can bring the database up in bypass recovery mode, and the tables with the corruption are not that important. The problem is I am having trouble droping these tables from the database - a simple drop database command does not work.
Is there a dbcc command which will allow me to drop a table? I am aware of the dbcc checkdb(db_name,drop) - was hoping there is something similar but for tablealloc ?????