[sqlite] how to customize the returned field name by PRAGMA

[chan wilson]

Hi,

 I am using "PRAGMA table_info(table-name);" to the the schema info of a 
table, but I could not customize the returned field name, such as:

 I wish "cid" to be ColumnID.

 normally we do by this:

 "SELECT cid AS ColumnID FROM (table-name);"

 but now I could not. is there anyway work out?

 THanks a lot!

_________________________________________________________________
与联机的朋友进行交流，请使用 MSN Messenger: http://messenger.msn.com/cn