CREATE INDEX IDX_FNAME ON PEOPLE COMPUTED BY (lower(fname))

This works fine and instead of traversing the entire table when performing a case insensitive query, an 'index read' for matching records is performed.

The question I have is that the database management utility I use does not show the true index DDL for my computed index.  This is what the utility shows:

CREATE INDEX IDX_FNAME ON PEOPLE();

Is my database management tool not showing this correctly or is this what the Firebird server returns?