On 8 May 2011, at 4:09pm, Simon Slavin wrote:

> On 8 May 2011, at 4:00pm, Sam Carleton wrote:
> 
>> Is there a
>> way to find out the id of a particular column?
> 
> It depends what you think a column's id is.  But SQLite maintains a 
> pseudo-column of INTEGERs called 'id' or 'rowid' (several other names) which 
> you can ask for by name.  For instance
> 
> SELECT rowid,* FROM myTable

Whoops.  Sorry I somehow understood that as 'rowid'.  Columns don't have ids.  
See Jean-Christophe's reply for better details.

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to