Most probably the change process has been interrupted, when you were changing the table.
As far as I know R: base creates a 'temp table' using names like this. Maybe you don't like the idea, but an unload and load is probably the best option. After the unload you have to remove all the items related to this table. Tony IJntema From: [email protected] [mailto:[email protected]] On Behalf Of Bernard Lis Sent: maandag 1 november 2010 18:32 To: RBASE-L Mailing List Subject: [RBASE-L] - Strange Table I need to get rid of this table (it seems to be a copy of the customer table) If I try to delete it, it says that a col is being referenced. Please help: I can't find where this col is being referenced. R>list constraint for 49ee1862 Table Name: 49ee1862 Id Type Column Name(s) Ref Table Name Ref Column Name(s) ------ ---------------- ------------------ ------------------ ------------------ #55 PRIMARY KEY CustomerNo Note that there is no ref Table Name and no Ref Col Name R>list fkeys Doesn't seem to shed any light on this -- unless I don't know how to interpret the Id# does the id shown below have any relation to a primary key or merely a number assigned to a foreign key? Id Type Table Name References ------ ----------------------------- ------------------ ------------------ #67 FOREIGN KEY ServiceContract OrderHeader #93 FOREIGN KEY Credits OrderHeader #78 FOREIGN KEY OrderTrucks OrderHeader #81 FOREIGN KEY ProposalDetail Proposal #82 FOREIGN KEY SCSchedule ServiceContract #83 FOREIGN KEY SCService ServiceContract #84 FOREIGN KEY SCOrders ServiceContract #88 FOREIGN KEY OrderRemark OrderHeader #89 FOREIGN KEY dbdummy2 DBDummy #90 FOREIGN KEY Debits OrderHeader #42 FOREIGN KEY Payments OrderHeader #65 FOREIGN KEY OrderDetail OrderHeader #63 FOREIGN KEY OldDtl OldHdr
