Subject | Re: [IBO] GetIndexNames |
---|---|
Author | Lucas Franzen |
Post date | 2001-10-01T12:23:56Z |
"Gerard J.M.Houtenbos" schrieb:
FROM RDB$INDICES
WHERE RDB$RELATION_NAME = <YOUR_TABLENAME>
(ADD: "AND RDB$INDEX_NAME NOT STARTING WITH 'RDB$' if you're only
interested in your own created indices; assuming you don't name them
RDB$xxx)
You can also get ALL indices from the
TIBConnection.SchemaCache.IndexNames.
But this (TIB_StringList) has got the format: INDEXNAME,RELATIONNAME
Luc.
>SELECT RDB$INDEX_NAME
> I'm converting an Interbase Delphi 4-application from the BDE to
> IBO.
> Somewhere I need a list of the indexes on a Table.
> I used to use TTable.GetIndexrNames for that purpose, but
> TIBOTable.GetIndexNames is not supported.
>
> Any solutions?
FROM RDB$INDICES
WHERE RDB$RELATION_NAME = <YOUR_TABLENAME>
(ADD: "AND RDB$INDEX_NAME NOT STARTING WITH 'RDB$' if you're only
interested in your own created indices; assuming you don't name them
RDB$xxx)
You can also get ALL indices from the
TIBConnection.SchemaCache.IndexNames.
But this (TIB_StringList) has got the format: INDEXNAME,RELATIONNAME
Luc.