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

Reply via email to