These weird named tables cannot be dropped by ordinary means. BUT they can be renamed and then dropped.
-- Dennis McGrath mailto:[EMAIL PROTECTED] -- Productivity Tools for R:Base Programmers http://www.enteract.com/~mcgrath/dennis -- Full time consultant with: SQL Resources Group Steve Hartmann Oak Park, IL mailto:[EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bill Downall Sent: Tuesday, October 23, 2001 10:24 AM To: [EMAIL PROTECTED] Subject: Re: Fw: Unload / Input problems Dave, The error message always FOLLOWS the command the caused the error. You listing looks like you were looking at the command that followed the error. To get rid of the bogus table -- which can be left over when an ALTER TABLE or object manager table SAVE fails or gets interrupted -- you may be able to use the NOCHECK option of DROP: DROP TABLE 3bd57d9f NOCHECK You may also have to put the table name inside your IDQUOTES character (default is the funny quote mark on the key to the left of the number 1). DROP TABLE `3bd57d9f` NOCHECK Bill On Tue, 23 Oct 2001 10:31:43 -0400 (Eastern Daylight Time), David Ebert wrote: > > > >From: David Ebert >Date: Tuesday, October 23, 2001 09:49:30 AM >To: [EMAIL PROTECTED] >Subject: Unload / Input problems > >A database suffered some kind of damage resulting in a table with a >name of 3bd57d9f (not one of mine) that was, in fact, a duplicate of another >table in the database. I've seen this done when an irregular exit occurs. >The "original" version of this table also lost the table reference for an FK >(no table in that column under "keys" in RBD. Changes did not work (drop FK > delete a previously-deleted rule (!)). Since I was unable to change the >structure I decided on the unload. > >As I've done before (although not with this database) I unloaded the >structure then the data. However, upon input I'm getting errors that I can >t figure out the way around: > >For example: >-ERROR- Default length must be no longer than 60 chars (2791) >The structure from the unload is: >CREATE TABLE `StMove` + >(`StMvID` INTEGER NOT NULL , + >`SID` INTEGER NOT NULL , + >`STitle` INTEGER , + >`Prog` INTEGER NOT NULL , + >`Dstart` DATE , + >`DEnd` DATE , + >`DLWk` DATE , + >`MvType` INTEGER , + >`MFTE` INTEGER ) >I don't see anything that could be > 60 chars. >Another: >-ERROR- Constraints must be separated by commas (2795) >CREATE TABLE `DiMarry` + >(`Val` INTEGER NOT NULL , + >`TVal` TEXT (6) , + >`TDesc` TEXT (45) , + >`Obs` TEXT (1) DEFAULT 'N' ) >Although the contraints load further down in the file. >and finally... >-ERROR- Illegal table name - DiRefout (2037) > >I've had other errors, but those mostly relate to load order (cut & paste >fixes that), but these are the stumpers. > >tia for any insight. > >Dave >[EMAIL PROTECTED]
