Bret,
SET RELATION TO will remove
all relations on the table, not just one.
Mark
>I'm not sure how that would work differently from SET RELATION OFF INTO childtable. However, what I actually did was to replace my REMOVE TABLE mytable DELETE with DROP TABLE mytable. It stopped complaining then.
>
>>Have you tried:
>>
>>SET RELATION TO
>>
>>?
>>Mark
>>
>>>I have a program to make a smaller version of a database. It copies all the files, then removed unneeded views, tables, and records. In order to delete some tables, I have to first remove their relations. I have been using SET RELATION OFF INTO childtable. There is one table whose relations are not getting removed. It is also the only table I'm removing that is related to two other tables, not just one. A couple of other tables that have one relation each are successfully removed before this one. What might I be doing wrong?
"It hit an iceberg and it sank. Get over it."
Robert Ballard, dicoverer of the Titanic wreckage.