DDL for SQL server generates ON DELETE RESTRICT

[micke911]

I am working on a data model targeted at SQL-server 2008. Running the command Tools/Database Engineering/Generate Package DDL generates the following constraint declaration in the result file:

Code: [Select]

ALTER TABLE schma.tbl ADD CONSTRAINT FK_RefTbl
      FOREIGN KEY (RefID) REFERENCES schma.reftbl (ID)
      [highlight]ON DELETE RESTRICT ON UPDATE RESTRICT[/highlight]
GO
ON DELETE RESTRICT ON UPDATE RESTRICT is not valid for SQL server 2008. Is this a bug?

[philchudley]

Check the relationship between the tables, right-click and select Foreign Keys...

You will most likely find that referential integrity has been checked on, hence the clause in the DDL

Unchecking the referential integrity checks will generate the DDL you expect

Cheers

Phil

[micke911]

Yes that seems to be the workaround. Since the RESTRICT directives are not valid in SQL server I think it would be correct not to have this as a default in the foreign key dialog.

Thanks a lot!

/Micke