>
> SAD_Database.Connected:= true;
>
> if not IndexExists then
> RunScriptToCreateIndex;
>
> ...

Hi,

FBConnection.SchemaCache.IndexNames shows a list of indexnames

FBConnection.SchemaCache.TableNames ...

etc

and:

'select RDB$FIELD_NAME as fieldname from RDB$RELATION_FIELDS '+
'where RDB$RELATION_NAME = ''Name_of_Table'''

shows a list of fieldnames from table NAME_OF_TABLE

hth!

John