"Jackson, Douglas H" wrote: > > This leaves you to parse the DDL from sqlite_master. > Doug
... or to correlate 'pragma table_info(tablename)' with 'pragma index_info(tablename)'. Some (unreadable, imperfect) example code can be found in the ODBC driver e.g. in the functions SQLPrimaryKeys(), SQLSpecialColumns(), SQLStatistics(), and the internal function fixupdyncols(). Regards, Christian