On May 24, 2017 11:33:13 AM EDT, Manoj Sengottuvel <smanoj...@gmail.com> 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';' > >I got the following result > > >type > >name > >tbl_name > >root_page > >Sql > >index > >sqlite_autoindex_ACCOUNT_MSTR_1 > >ACCOUNT_MSTR > >3 > >NULL > >When I am seeing in the result sql column is NULL. > >Why the sql column shows NULL value? > >Do I need to create the index for the primary key? > >But the same case if I create my own index for the table (table name : >ACCOUNT_MSTR) then I can able to see the index creation script in sql >column . > >I don't understand how the auto index is working? > > > >Regards, > >Manoj. >_______________________________________________ >sqlite-users mailing list >sqlite-users@mailinglists.sqlite.org >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
The "sql" field contains the statement executed to create the table/index/trigger/etc. Automatic indexes are a side-effect of table creation, and so have no associated statements. -- J. King _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
