chan wilson wrote: > 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? > > There is no way to alias the column names returned by pragma commands since they are not normal SQL queries. You will have to translate the names in your application (the code that is issuing the pragma commands).
Dennis Cote