[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