• Monday , 1 June 2020

SQL tutorial 19: ON DELETE SET NULL clause of Foreign Key By Manish Sharma (RebellionRider)

Code Canyon



SQL Tutorial 19 : ON DELETE SET NULL foreign key Clause. Links used in the tutorial On delete set null website article [ download SQL script from same link] …

Original source

3d Ocean

Related Posts

17 Comments

  1. GAVI GHUMMAN
    August 30, 2018 at 00:34

    Your Voice reminds me of "FARHAN AKHTAR"

  2. Babak Elikaee
    August 30, 2018 at 00:34

    tnx Manish. you are doing great. I need to add a comment I think drop foreign key and re-create it missed.
    ALTER TABLE books DROP CONSTRAINT bok_col3_fk; — drop foreign key
    ALTER TABLE books ADD CONSTRAINT bok_col3_fk FOREIGN KEY (book_author_id) REFERENCES authors(author_id) ON DELETE SET NULL;

  3. Wenmei Ming
    August 30, 2018 at 00:34

    Nice lectures. Appreciate your great work. Thanks, man.

  4. Abhrajit Ghosh
    August 30, 2018 at 00:34

    Qq. instead of dropping the table books, cant we just drop the foreign key constraint? And then add it back using alter table statement?

  5. multitelentsworks shivani patelzzz
    August 30, 2018 at 00:34

    sir plese ap ap ke videohindi me upload karte to hindi ya gujrati media valo ko bhi acha hota

  6. Prem Kumar Inti
    August 30, 2018 at 00:34

    i should thank you for this video, i had a confusion about this constraint,,,,,,,,,,,,,,,,,,,,,but after watching this………..i clearly knew about this…………..thank you manish

  7. Nupur Singh
    August 30, 2018 at 00:34

    Very good videos. Getting a thorough understanding of concepts. You should think of creating tutorial videos for websites like Udemy. Its just a suggestion as you will get wider student audience. Best Of luck!!

  8. Bhasker Kaveti
    August 30, 2018 at 00:34

    Hi Manish, Thanks for your tutorials.
    I have a question, why am i not able to see any data under user_constraints table, any idea. I created Child table under HR schema and when i run user_constraints no data is returned.

  9. H0LDENSUX
    August 30, 2018 at 00:34

    Thanks for this tutorial Manish. I was wondering if you can set another value like Nil instead of Null when deleting a foreign key? The reason I ask is because in database at work, when I remove a relationship between some object tables, the business rule states that I need to remove the applicability of that object, where an applicability of that object can be more than 1 variable across multiple rows. In that situation where the primary key in a parent table existing in the children table more than once as shown by the multiple rows, is there a way to set the delete to Nil to change the objects applicability?

  10. Jyotimoi das
    August 30, 2018 at 00:34

    The video tutorials are great !!! Thanks a lot #Manish .!!!

  11. Abdullah saad
    August 30, 2018 at 00:34

    really good job and great job
    its help me a lot to learn SQL thank you very mush Mr.Manish

  12. Sanoberjahan Ansari
    August 30, 2018 at 00:34

    doing a god job ,really your videos are awesome !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
    it helps me a lot to learn SQL .

  13. Fab TV
    August 30, 2018 at 00:34

    Very good thanks

  14. Mohammad Hannan
    August 30, 2018 at 00:34

    really  nice and educational vedio.Many Many  thanks.I pray for you .

  15. Ashwin kumar singh
    August 30, 2018 at 00:34

    hello manish,

    i am facing a problem in oracle 11g. whenever i am trying to connect https://localhost:1158/em, it gives me this Error code: ERR_CONNECTION_REFUSED.

    after installing the oracle 11g it worked fine. next day when i tried, i am getting this issue.

    please help me to fix this.

    thankyou in advance.

  16. איציק א
    August 30, 2018 at 00:34

    Great

  17. info s
    August 30, 2018 at 00:34

    Diference Between & and && in SQL WITH example.

Leave A Comment

You must be logged in to post a comment.