| Subject | Re: [ib-support] index a Foreign Key? |
|---|---|
| Author | Helen Borrie |
| Post date | 2003-06-04T23:03:24Z |
At 11:05 AM 4/06/2003 -0700, you wrote:
RDB$FOREIGNnn (where nn will be digits). The constraints have names like
INTEGnn.
If you want an easy way to inspect them and their dependencies, per table,
get hold of the free IB_SQL tool from www.ibobjects.com and use its Browse
tools.
heLen
>Hi,Yes: not only unnecessary but undesirable. The FK indexes have names like
>
>I'm trying to clean up some old tables, and I can't find where this is
>explicitly stated.
>
>Are foreign keys automatically indexed like primary keys, therefore making it
>unnecessary to create separate indexes?
RDB$FOREIGNnn (where nn will be digits). The constraints have names like
INTEGnn.
If you want an easy way to inspect them and their dependencies, per table,
get hold of the free IB_SQL tool from www.ibobjects.com and use its Browse
tools.
heLen