Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
aprichard
Yak Posting Veteran
62 Posts |
 Posted - 2008-05-27 : 02:50:14
|
| Can any one u explain "ON UPDATE NO ACTION While Creating Table" |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-05-27 : 03:11:10
|
See http://msdn.microsoft.com/en-us/library/aa933119(SQL.80).aspx
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-27 : 03:33:05
|
quote:
Originally posted by aprichard
Can any one u explain "ON UPDATE NO ACTION While Creating Table"
Its a clause used in definition of foreign key constraint. It suggests that if the source key is updated you dont require any changes to be done to value of foreignkey. The other option is ON UPDATE CASCADE which suggests any updation to main table causes automatic updation of referencing field value. |
|
|
|
|
|
|
ON UPDATE NO ACTION