Hi,

I have a small database app using IBO TIOBTable and the firebird
embedded server. I would like to know if it is possible to detect if an
index exists on a table. since I have many apps installed this would
allow me to upgrade the tables if required from the client as an easy
way to upgrade. I am looking to be able to do something like this.

SAD_Database.Connected:= true;

if not IndexExists then
RunScriptToCreateIndex;

...

Wondering also if presence of fields could also be detected prior to
opening the dataset.

Thanks