Getting Constraints information

[Morpheus1981]

Using "user_constraint" I am able to know when a relation has CASCADE or Restrict "Delete Rule" when I deletes, but I would like to know that if there's and UPDATE if the update is CASCADE or Not.

Does anyone now how I can get this information from ORACLE DataBase? (It can be any not only through user_constraint view).

Thank you.

 

[Turkbear]

Try here for full info on Update Cascade ( it is not a std function ):

http://osi.oracle.com/~tkyte/update_cascade/index.html

hth,