Re: FK-constraints without corresponding index, how to find with SQL ?

In article <818195535snz_at_jlcomp.demon.co.uk> I wrote:

: An index which 'satisfies' the foreign key constraint need not
: have the same columns in the same order. In fact it could have
: more columns than the constraint anyway just so long as the N
: constraint columns appear somewhere in the first N columns of
: the index.

Sorry, folks, I only got it half right.

Although the index can have extra columns tagged on to the end, the columns that match the foreign key constraint have to be in the right order.

-- 
Jonathan Lewis