Using RBWin 6.5++
I wanted to add a cascade option to my PK/FK relationship,
so I did a:
ALTER TABLE Loads ADD CASCADE
after my keys were defined. I got no message of any kind,
unloading the structure doesn't indicate anywhere that the
cascade is set up. Don't see it in listing the table or
the constraints.
I thought it didn't work until I tested it by deleting a row
in my PK table and it did delete the rows in the FK table.
So it worked, but I don't like the fact that I can't find
anywhere that the cascade exists! Is there anywhere in the
structure that I can find this out? If I was looking at
someone else's database, how would I find this out?
Karen

