sql: get a list of field names from a data table

Well, almost as soon as I posted my message I worked out how to do it using the Qt sqlite binding:

QSqlQuery q("select * from mytable LIMIT 0, 0"); //don't actually select anything but get a reference to the record set

QSqlRecord rec = q.record();

QStringList fields;

for (int i=0; i<rec.count(); i++)
fields.append(rec.fieldName(i));

//now, fields contains a list of field names

But if there's a pure sql way of doing it I'd love to know!

Cheers

Mick