Try select * from sqlite_master where tbl_name='yourTableName' and type='index'
This is all explained in the Create Table section of lang.html and in the FAQ. Regards --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]