subject:"\[sqlite\] sqlite

Re: [sqlite] sqlite_master structure

2017-11-01 Thread 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

Re: [sqlite] sqlite_master structure

2017-11-01 Thread 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

Re: [sqlite] sqlite_master structure

2017-11-01 Thread 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

[sqlite] sqlite_master structure

2017-11-01 Thread 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] sqlite_master and sessions

2012-08-15 Thread Charles Samuels

Hi, I'm using the Sessions extension, and I'm seeing a problem in which when calling sqlite3session_changeset(), it calls sessionSelectStmt with zTab="sqlite_master", which fails because that table has no primary key. I'm doing sqlite3session_attach(d->sqlSession, 0), so that should include "a

Re: [sqlite] sqlite_master table does not show all available tables....

2006-09-26 Thread Nemanja Corlija

On 9/26/06, Mark Pirogovsky <[EMAIL PROTECTED]> wrote: One can query the sqlite_master table to find out all the available tables and views. However if you open (via ATTACH [DATABASE] sql command) more then one database files in the sessions, the sqlite_master only shows the tables in the lat

[sqlite] sqlite_master table does not show all available tables....

2006-09-26 Thread Mark Pirogovsky

One can query the sqlite_master table to find out all the available tables and views. However if you open (via ATTACH [DATABASE] sql command) more then one database files in the sessions, the sqlite_master only shows the tables in the latest opened file. Is there a way to see all the tabl

Re: [sqlite] SQLite_master information on website

2006-08-06 Thread John Newby

Hi Gerry, thanks for this info, much appreciated. John. On 07/08/06, Gerry Snyder <[EMAIL PROTECTED]> wrote: John Newby wrote: > Hi, can anyone direct me to the right page relating to the sqlite_master > table please, I am unable to find it on the website. I do not know of a single complete de

Re: [sqlite] SQLite_master information on website

2006-08-06 Thread Gerry Snyder

John Newby wrote: Hi, can anyone direct me to the right page relating to the sqlite_master table please, I am unable to find it on the website. I do not know of a single complete description (other than the source code). The table is discussed near the bottom of the CREATE TABLE page in the sy