Exception to foreign key constraint

• Alex Dess

  Mr or Mrs. 500

  Points: 506

  More actions

  March 16, 2009 at 10:51 pm

  #97364

  We have two tables:

  create table Currency (

  CurrencyID CHAR(3) not null primary key,

  Name varchar(70) not null)

  Create table CurrencyClosed (

  CurrencyID CHAR(3) not null,

  StartDateTime datetime not null,

  EndDateTime datetime not null,

  Desciption varchar(1000) not null)

  Obviously we want this foreign key constraint:

  alter table CurrencyClosed

  add constraint FK_CurrencyClosed__CurrencyID

  foreign key (CurrencyID)

  references Currency(CurrencyID)

  However we also want to have rows in CurrencyClosed that represent when every currency is closed. What is the best method to do this? What are the pros & cons of the various different options?

  - EBH

  If brute force is not working you're not using enough.

• SQL_DBA_3

  SSCarpal Tunnel

  Points: 4772

  More actions

  March 17, 2009 at 12:12 am

  #960818

  Create a AFTER TRIGGER for INSERT....or you need to manually insert the rows in currencyclosed table everytime.