This is true with one exception, if you create an INTEGER PRIMARY KEY, SQLite will use this instead [1].
[1]: https://sqlite.org/rowidtable.html