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"
I was wondering if anyone knew how to change an existing integrity
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!
create table employees
ID num primary key,
create table salaries
ID num references employees on delete restrict
on update set null,