Re: [sqlite] sqlite_master structure
On 2 Nov 2017, at 5:05am, Igor Korot wrote: > So if I want table, it is cleaner to use tbl_name, correct? > Provided I have "WHERE type = 'table'" in the query... For that specific thing, the two are always the same. I think that it might make more sense to use "name" because that’s what you would do if you were looking for indexes. Simon. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] sqlite_master structure
Simon, On Wed, Nov 1, 2017 at 10:44 PM, Simon Slavin wrote: > > > On 2 Nov 2017, at 3:37am, Igor Korot wrote: > >> I see that sqlite_master have 2 fields: name and tbl_name. It looks >> like they have >> the same value in my case. >> >> Is there a scenario when those 2 are different? > > sqlite_master includes rows for things that aren’t tables. For example, > indexes. So if I want table, it is cleaner to use tbl_name, correct? Provided I have "WHERE type = 'table'" in the query... Thank you. > > Simon. > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] sqlite_master structure
On 2 Nov 2017, at 3:37am, Igor Korot wrote: > I see that sqlite_master have 2 fields: name and tbl_name. It looks > like they have > the same value in my case. > > Is there a scenario when those 2 are different? sqlite_master includes rows for things that aren’t tables. For example, indexes. Simon. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] sqlite_master structure
Hi, ALL, I see that sqlite_master have 2 fields: name and tbl_name. It looks like they have the same value in my case. Is there a scenario when those 2 are different? And what should I check for the "table name"? Thank you. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users