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