Bernie Have you tried renaming the table. You will have to use the IDQuotes when doing so. Once it is renamed use the "Design Table" and then look at the keys. Try dropping the key from there. If that fails then I would suggest unloading all to a file (test.all) and then edit file and manually remove the structure and any data for that table. Once done run the file (test.all) to reload the database.
Needless to say but make sure you are working on a copy of the database. Buddy From: [email protected] [mailto:[email protected]] On Behalf Of Bernard Lis Sent: Monday, November 01, 2010 1:32 PM 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
