I know in SQL Server that you can create SQL statements to return information based solely on table structure as well as index information. Is there anything in DBISam SQL that would allow me to return this information? I'm working on building scripts to test the table structure and check indexes in existing databases. Thank you.

There is nothing built-in to do that. It's trivial to do this in Delphi
code and if you're using ODBC then some of that data is surfaced thru
odbc schema  tables.

You can use IF NOT EXIST clause when creating tables and indexes but not
to otherwise query for them.

The newer EDB product does have all that capability.

Raul

On 12/15/2011 1:08 PM, JansB wrote:
> I know in SQL Server that you can create SQL statements to return information based solely on table structure as well as index information. Is there anything in DBISam SQL that would allow me to return this information? I'm working on building scripts to test the table structure and check indexes in existing databases. Thank you.>

Thank you for the reply, that is good to know.