Book a Demo

Author Topic: How to model foreign key constraints NO data check  (Read 1949 times)

Amko Hartman

  • EA Novice
  • *
  • Posts: 1
  • Karma: +0/-0
    • View Profile
How to model foreign key constraints NO data check
« on: May 11, 2009, 11:34:25 pm »
Does any one know how you can model a foreign key within Enterprise Architect and set it to no data check. So it does not check data if the column stays empty?

Result for SQL Server should be

ALTER TABLE MyTable1 WITH NOCHECK ADD CONSTRAINT FK_MyTable1_MyTable2
      FOREIGN KEY (MyTable1Id) REFERENCES MyTable2 (MyTable2ID)
;
ALTER TABLE MyTable1 NOCHECK CONSTRAINT [FK_MyTable1_MyTable2]
;

Can any one help me how I do this within Enterprise Architect?

Greetings Amko Hartman