[RBASE-L] - Re: Mystery Table

[A. Razzak Memon]

At 01:01 AM 1/26/2009, Tom Frederick wrote:

This evening a mystery table showed up in my database. Name is '497ca322'.

Tom,

That is the result of un-finished, and improperly closed "virtual copy"
of the actual table being modified, while in Data Designer (RBDefine).

To DROP this table, first you need to RENAME the `497ca322` table name
that starts with a text, and then you should be able to DROP that ghost
table.

You may use Database Explorer | Tables or try the following commands at
the R> prompt:

RENAME TABLE `497ca322` TO `JunkTable` NOCHECK
DROP TABLE `JunkTable`

-- Note the ghost table name enclosed by IDQUOTES character.

That should take care of the ghost table.

Make sure to RELOAD the database, if deemed necessary.

Very Best R:egards,

Razzak.