-On [20030908 20:52], Rod Taylor ([EMAIL PROTECTED]) wrote: >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 was more interested in this feature for CHECK constraints. :) >I think this is a more consistent syntax: >ALTER TABLE .. ADD OR REPLACE <table constraint> I was following Oracle's example here for sake of some consistency between some RDBMSes. -- Jeroen Ruigrok van der Werven <asmodai(at)wxs.nl> / asmodai PGP fingerprint: 2D92 980E 45FE 2C28 9DB7 9D88 97E6 839B 2EAC 625B http://www.tendra.org/ | http://www.in-nomine.org/~asmodai/diary/ Gravitation can not be held responsible for people falling in love... ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
