drop table `56da0c5f` NOCHECK You have to use your IDQUOTES symbol around the table name, and include the "nocheck"
Karen -----Original Message----- From: Jim Belisle <[email protected]> To: karentellef <[email protected]> Sent: Sat, Mar 5, 2016 11:10 am Subject: [RBASE-L] - RE: Mystery table generated during a crash Kaleb, I would backup your DB then do an unload, reload. See if that helps. James Belisle Making Information Systems People Friendly Since 1990 [cid:[email protected]] From: [email protected] [mailto:[email protected]] On Behalf Of Kaleb Wade Sent: Saturday, March 05, 2016 11:04 AM To: Jim Belisle Subject: [RBASE-L] - Mystery table generated during a crash I was in the processes of fixing a mistake in a query and tried to check my progress by opening the query to view the data. In doing so, the R:BASE became unresponsive and my pc prompted me to close the program. Upon reopen and reconnecting to the database, one of the table involved in the query had duplicated itself, but with a different name "56da0c5f". I get the following error when trying to delete the table: -ERROR- This table is referenced by a Foreign Key - unable to drop table. (2720) I am not able to find where the table is referenced. Any suggestions? Kaleb Wade 2600 N. Stemmons Frwy., Ste. 117 Dallas, TX 75207 Ph: (214) 638-0484 │ Fx: (214) 630-5140
