title: TSQL alter table adding constraint for both cascade on delete and update
body: <p>I'm trying to create a constraint with both on update and delete in tsql.  I've tried a couple of different methods, and now I'm a little stuck &amp; frustrated - seems so simple.  I know you can't alter an existing constraint so I'm not sure about how to do this;</p>
  
  <pre><code>alter table AllowedCars 
     add constraint FK_AllowedCars_CarID foreign key (CarID) 
        references Cars(LocusID) on delete cascade, 
  constraint FK_AllowedCars_CarID foreign key (CarID) 
     references Cars(CarID) on update cascade
  </code></pre>
  
  <p>or this;</p>
  
  <pre><code>alter table AllowedCars add constraint FK_AllowedCars_CarID foreign key (CarID) 
     references Cars(CarID) on delete cascade and on update cascade
  </code></pre>