RESTRICT is unknown as foreign key action for MSSQL.
Semantically, restrict means that an error should be thrown by the database if the foreign key is invalid.
This corresponds to the MSSQL action NO ACTION.
Thus, on delete="restrict" should be rendered in MSSQL's SQL as ON DELETE NO ACTION.
Likewiese for onUpdate.
|Field||Original Value||New Value|
|Summary||onUpdate="restrict" and onDelete="restrict" cause sql syntay error in MSSQL||onUpdate="restrict" and onDelete="restrict" cause sql syntax error in MSSQL|
|Status||Open [ 1 ]||Resolved [ 5 ]|
|Assignee||Thomas Fox [ tfischer ]|
|Resolution||Fixed [ 1 ]|
|Status||Resolved [ 5 ]||Closed [ 6 ]|