Re: [sqlite] Regarding Sqlite DB Index

2017-05-24 Thread Richard Hipp
On 5/24/17, Manoj Sengottuvel wrote: > > If I create new table (table name : ACCOUNT_MSTR) then the auto index is > created as sqlite_autoindex_ACCOUNT_MSTR_1. > > Then I am trying to execute the following query ' select * from > sqlite_master where type='index';' > > I got the following result [

Re: [sqlite] Regarding Sqlite DB Index

2017-05-24 Thread J. King
On May 24, 2017 11:33:13 AM EDT, Manoj Sengottuvel wrote: >Hi Richard, > >If I create new table (table name : ACCOUNT_MSTR) then the auto index >is >created as sqlite_autoindex_ACCOUNT_MSTR_1. > >Then I am trying to execute the following query ' select * from >sqlite_master where type='index';' >

[sqlite] Regarding Sqlite DB Index

2017-05-24 Thread Manoj Sengottuvel
Hi Richard, If I create new table (table name : ACCOUNT_MSTR) then the auto index is created as sqlite_autoindex_ACCOUNT_MSTR_1. Then I am trying to execute the following query ' select * from sqlite_master where type='index';' I got the following result type name tbl_name root_page Sql