Date:         Sat, 24 Sep 2011 17:29:00 -0400
Reply-To:     bbser 2009 <bbser2009@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         bbser 2009 <bbser2009@GMAIL.COM>
Subject:      how to change  existing integrity constraints
Content-Type: text/plain; charset="us-ascii"

Greetings!

I was wondering if anyone knew how to change an existing integrity
constraint.
For example, consider the code below.
After running it, how to change the foreign key rule "on delete restrict" to
be "on delete cascade"?

Any comments or suggestions are appreciated!

Max
(Maaxx)
========================
proc sql;
        create table employees
        (
                ID num primary key,
                Name char(10)
        );

        create table salaries
        (
                ID num references employees on delete restrict
                        on update set null,
                Salary num
        );
quit;