|Subject||Re: [firebird-support] Newbie: A few questions...|
> > > > > You can create DESC primary (and matched order foreign) keys inok - this is what I thought you were saying. My question was:
> > > >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?
> No; it means if you create a USING <indexname> DESC primary key, any
> foreign keys pointing to it must also be USING <indexname> DESC (as
> explained in the release notes).
what happens if they don't match?
> Is that better for you than a B*m****M? Or nearly as good?Not quite as good ;-)
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL