On Mon, 2003-09-08 at 14:32, Jeroen Ruigrok/asmodai wrote: > Hi people, > > can someone add: > > Add an ALTER TABLE MODIFY CONSTRAINT > > item to the todo list? I am even willing to pick this one up in a > while, after I finish some other outstanding tasks.
This could be rather time consuming to actually write but having the ability to change foreign key on update / on delete modes without rechecking all of the data would be very useful. I think this is a more consistent syntax: ALTER TABLE .. ADD OR REPLACE <table constraint>
signature.asc
Description: This is a digitally signed message part