SQLite Forum

Table Btree and Index Btree
Login
I read from the documentation that there are 2 kinds of B-Tree in SQLite: Table Btree and Index Btree. My question is "When I create a table 'Create table Numbers( Number integer not null);' and then insert some numbers into it, is the data managed in an Index Btree or Table Btree and what if I use 'create index' command then? Sorry for my bad English and thanks in advance.