At 08:56 PM 10/28/2010, Bernard Lis wrote:
I did that but my real problem is that a new table suddenly
appeared. The name of the table is 49ee1862 Looking at the
data in the table it is an image of another table. I can't
seem to get rid of that table because it is referenced.
When I did list keys, that table does not show up. Any ideas
what I should try next?
That is the result of un-finished process while in data designer.
Here's how to DROP that table.
01. CONNECT dbname
02. Make sure that the database IDQUOTES SETting is set to `.
It is the reversed single quote on the same key with "~".
You may correct this settings as:
SET IDQUOTES=`
03. Now rename the ghost table.
RENAME TABLE `49ee1862` TO JunkTable NOCHECK
04. DROP TABLE JunkTable
That's all there is to it!
Very Best R:egards,
Razzak.
