Bernie, List Constraints doesn't show the lost/broken ones.
Start the database explorer. Go to Tables. Right-click on each table, and choose "Design table." Click on the tab for Indexes and Keys. Then click on each foreign key, and make sure it shows the correct table and column. If not, delete the key, save the table, come back and create it again. Bill On Mon, Nov 1, 2010 at 5:00 PM, Bernard Lis <[email protected]> wrote: > Hi Bill, > I checked all the tables that reference the CustomerNo and all look ok > (they show up in List Constraints). > But I'm not sure how to do the following: > "But when you click on the individual key, you don't see the correct > referenced table and column in the other box" > Where do I go to click on the individual key? I clicked where I saw it but > nothing happened. > > Also an interesting thing ocurred on the way to the forum: > I copied the database and the original has id #92 for the table 49ee1862 > and the copy has it as #55 > Also the list constraints on the copied database is in a different order. > Is this normal? Or do I have another problem? > > ----- ..Original Message ----- > *From:* Bill Downall <[email protected]> > *To:* RBASE-L Mailing List <[email protected]> > *Sent:* Monday, November 01, 2010 2:18 PM > *Subject:* [RBASE-L] - Re: Strange Table > > Bernie, > > Primary Keys don't have ref Table Names or ref Column Names. Only Foreign > Keys do. > > The problem constraint is not a constraint on 49ee1862, it is a constraint > on some other table that probably should be pointing to Customer, but is > instead pointing to 49ee1862, or to nowhere at all. > > Just do a LIST CONSTRAINTS command, and look through it carefully for > foreign keys that either: > a) have a ref table of 49ee1862, or > b) have *no* ref table or ref column at all > > That is or those are the constraints that need dropping. It's not any > constraint you would see with LIST CONSTR FOR TABLE, and the ones with no > valid reference table don't appear to show up with LIST FKEYS, either. > > Your only PK in Customer is a CustomerNo. Go into DB Designer/Tables, and > look at every table that has a CustomerNo column (by that name or any other > name), and check all of the KEYS/Indexes. You may find some that don't show > up in LIST CONSTRAINTS and don't show up in LIST FKEYS, but are damaged > partial FK's anyway, and that do appear in the list of Keys and Indexes in > the table designer. But when you click on the individual key, you don't see > the correct referenced table and column in the other box.. > > Drop those constraints in the DB Designer. Save your changes. Then go back > in and build them again correctly. > > Bill > > On Mon, Nov 1, 2010 at 1:32 PM, Bernard Lis <[email protected]> wrote: > >> 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 >> > >
