Showing rowids with records in SQLite

Question

How can I show rowids with records in SQLite while it is displayed

Pravin More · Answer

Hi Monika you can show rowid by below query........ SELECT rowid* FROM Tablename; Note:- but its ok id you just want to show it..... but if you want to perform somthing on it then it may create problem.... i mean to say if you are going to show records in combobox on the basis of rowID then it may change when record will deleted..... Thanksi hope it will help you. Pravin.