ROWID

say it: “ROH-EYE-DEE” /ˌroʊˌaɪˈdi/

The hidden row number every table has.

What is ROWID?

Every normal SQLite table has a hidden ROWID; an INTEGER PRIMARY KEY column becomes an alias for it.

Level: Apprentice · More SQLite terms at this level

Updated