Re: [sqlite] sqlite_master structure

[Simon Slavin]

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

[Igor Korot]

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

[Simon Slavin]

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

[Igor Korot]

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