>> For the record, if you want a CONSTRAINT, then create a CONSTRAINT,
>> not an INDEX.
>
> Doesn't matter. Same behavior. I created index, because later I
> created filtered index.

Same behaviour, just because MS SQL is non-standard. In Firebird,
you cannot create a foreign key constraint to an index.

Use indices for filtering/speed, constraints for (business) rules.


With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum:
http://www.databasedevelopmentforum.com