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
