Search results

  1. H

    How to make an SQL Script to alter ALL Foreign Keys to add ON DELETE SET NULL for some specific Schema

    I have a lot of Foreign Key Columns with cascade delete set to NO ACTION in some specific Schema and I want to Set the FK Columns to ON DELETE SET NULL (for Example) where Primary Key Column's Schema relating to this Foreign Key Column is starting with 'Store'. I found some codes like this one...
Back
Top Bottom