[thelist] [SQL] deleting records from associated tables
Sean German
ethanol at mathlab.sunysb.edu
Fri May 24 09:57:08 CDT 2002
Howdy,
I'm working with MS-SQL 2000, which does have cascading referential
integrity constraints, which just happens to be just the thing I need.
Once again, not only have you answered the question I asked, you answered
the question I meant to ask =) I don't know if the relational integrity
rules were defined when the child tables were created, but the database is
well constructed, and I can add constraints with ALTER TABLE. It's nice
to come into a company and get right to work, as opposed to cleaning up
the last guy's mess.
I flew out to a client Monday, my ears still haven't un-popped. This
makes my whole head and it's usual functions feel a little bit off kilter.
Thanks again,
Sean G.
--- rudy <r937 at interlog.com> wrote:
> > the central table is tblTracking, with the
> > records to be deleted in tblTrackingDeletions.
>
> hi sean
>
> that's good, and shows the designer was thinking
>
> > Other tables are joined with tblTracking by foreign key.
>
> so, um, do you have relational integrity in your database?
More information about the thelist
mailing list