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 >
