constraints: no action vs. restrict
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: constraints: no action vs. restrict

  1. #1
    Join Date
    Jan 2001
    Posts
    63
    I am trying to understand the difference between Oracle's default of "no action" on a constraint, and using "restrict". I have found some info in the documentation, but cannot find any examples of using "restrict". Can someone explain it and give a restrict example?

    Thanks in advance,

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828
    they apply to the what action to be taken on the child table

    restrict

    a)if you try to delete the parent record then oracle will restrict you bcoz there is a corresponding child record associated with it.

    no action

    b)if you delete the parent record then the child record would not be deleted (no action) and the record would be left as it is.

    i hope i am simple and clear

    regards
    hrishy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width