Karen,
CASCADE option is TABLE specific.
Cascade is applied to the table with PRIMARY KEY and is valuable to update a primary key value and to cascade the change from the PRIMARY KEY to the REFERENCED FOREIGN KEY Columns.
In your case it was Loads.
At the mighty R> prompt, type:
LIST Loads
After the Table name and Description, you'll notice the additional option of Flags: CASCADE
If you don't know the table name, simply type:
LIST TABLES ALL
That will give you list of all tables along with details, including CASCADE Flags (if any).
Have Fun!
Very Best R:egards,
Razzak.
At 07:32 PM 6/27/2003 -0400, Karen Tellef wrote:
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?
