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
m227
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.
Michał

MaximG
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 https://www.sqlite.org/lang_createtable.html#rowid.

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: https://www.sqlite.org/lang_createtable ... imkeyconst

Post Reply