|
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;
| 
