>> If I insert a record [sic] in A that record [sic] should be inserted
in B. If I delete a record [sic] in A that record [sic] should be
deleted from B. <<
If you have two identical tables in the same schema, you have a
redundancy and need to get rid of one of them.
If this was a file system -- where they DO have records and not rows
(HUGE difference)!! -- then you might expect this sort of design.
Back in the 1950's we would often take one tape and make mulitple copies
of the data, sometimes in a different order, so we could run several
reports at the same time. Is this what you are doing?
--CELKO--
===========================
Please post DDL, so that people do not have to guess what the keys,
constraints, Declarative Referential Integrity, datatypes, etc. in your
schema are.
*** Sent via Developersdex
http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!