RE: Design question with shared tables

SSC Guru

Points: 323504

June 22, 2012 at 8:26 am

my first suggestion is to change the names of the primary keys in the core tables themselves: DoorID, FinishID, and LeafID for example, based on your image you posted.

you (in my opinion) correctly named the foreign key IDs, but for me, the column name in the Primary table needs to always be the exact same name in the child tables.

if you can provide the DDL of the tables, a couple of sampel rows that show the issue, as well as the delete statement you are trying to do, we can help .

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!