On 3 May 2010, at 8:14am, yogibabu wrote: > like this: SELECT --idcolumn-- FROM `table`
If you always want to use a unique integer to refer to a record, you can ask for the column called '_rowid_' even if you didn't define one. You can use this in SELECT and UPDATE commands, as long as you don't close the database or do a VACUUM between them, because this can change the _rowid_s. If you want to figure out what the actual primary key is (it may be more than one column) you can use a combination of these two: PRAGMA index_list(table-name) PRAGMA index_info(index-name) See http://www.sqlite.org/pragma.html Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users