At 11:40 AM 20-01-02 +0100, you wrote:

>with Interbase:
>
>1. can I have the same index name for different tables ?

No. Each index is a database object in its own right so it must be unique.

>2. with which command - say from WISQL - do I list all indexes created for
>a given table ?

Use the SHOW command in isql or it's graphical equivalent in wisql - pick INDICES and select the ones you want, or all. I don't think you can request them per table, though - but the output tells you the names of the tables that own them.

You would probably find the Browse tool of IB_SQL more useful for this kind of investigation. Position the cursor on the table and then click the Index tab. (Also has tabs for triggers, field definitions, etc.)

http://www.ibobjects.com/IB_SQL_EXE.zip

(it's free).

regards,
Helen


All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org
_______________________________________________________