> > > You can create DESC primary (and matched order foreign) keys in

Firebird

> >1.5.
> >
> >Oh yes, I forgot about that one. Quick question (and without trying):
> >what happens if you mix an ASC FK index with a DESC PK index?
>
> Read my statement again....and give yourself a Bamsemum, quick!!

Sorry. still don't get it (don't have any Bamsemums though)...

If you create an FK that points to a DESC PK, will it automatically
create a DESC FK?


With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com