Hi Bret.

>In order to delete some tables, I have to first remove their relations. I have been using SET RELATION OFF INTO childtable.

That won't work -- SET RELATION is for temporal relations (those set using the SET RELATION command), not for persistent relations. You have to use ALTER TABLE DROP FOREIGN KEY in the child tables to remove the persistent relation, then you can DROP TABLE or REMOVE TABLE to remove the parent. If you want to keep the index in the child table but just remove the relation, add the SAVE keyword in ALTER TABLE.

Doug