internal rowid field

Discussion of open issues, suggestions and bugs regarding LiteDAC (SQLite Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Posts: 59
Joined: Mon 06 Aug 2007 12:41

internal rowid field

Post by m227 » Wed 17 Feb 2016 13:44

Dear Sirs,
I found that when opening SQLite tables with external programs usually I see field named rowid. Do I need to create my own Primary Key field in a table or is there already an existing rowid field (with TLiteTable)?

I could not find any.

Devart Team
Posts: 1030
Joined: Mon 06 Jul 2015 11:34

Re: internal rowid field

Post by MaximG » Thu 18 Feb 2016 12:32

Description of working with the special ROWID field in SQLite is available at

The special ROWID field is used by SQLite for its own purposes and doesn't substitute the primary key. In order for a table to have a primary key, you should create it explicitly: ... imkeyconst

Post Reply