At 08:13 AM 6/19/2001 +0000, jvanderreest@... wrote:

>...We have
>existing data that violates the constraints we wish to put in place.
>Primarily we would like to create 'Foreign Keys' on specific columns
>to ensure that any NEW data entered is 'valid' but any existing data
>is ignored for historical reasons.

I'd suggest using triggers rather than foreign key constraints.
Define the triggers after you have the data loaded.

> MS-SQL Server provides the key
>words 'NO CHECK' when declaring constraints, which allows current
>data to be ignored when porting from another database engine. Is
>something similar available in interbase?

No, though there might be something in Firebird sooner or later.

Regards,

Ann
www.ibphoenix.com
We have answers.