Re: [sqlite] sqlite system table names

[drh]

Ralf Junker <[EMAIL PROTECTED]> wrote:
> >sqlite_master is it.  there are no others.
> 
> How about sqlite_temp_master? Or database.sqlite_master for connected 
> databases? 
> 

OK.  Them too.
--
D. Richard Hipp   <[EMAIL PROTECTED]>

Re: [sqlite] sqlite system table names

[Ralf Junker]

>sqlite_master is it.  there are no others.

How about sqlite_temp_master? Or database.sqlite_master for connected 
databases? 

Re: [sqlite] sqlite system table names

[Jay Sprenkle]

On 6/13/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:

Hi,
I want to know the names of the system tables in sqlite. I only know of the 
table sqlite_master.


try this:

select * from sqlite_master
where type = 'table'

Re: [sqlite] sqlite system table names

[drh]

"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote:
> Hi,
> I want to know the names of the system tables in sqlite. I only know of the 
> table sqlite_master.

sqlite_master is it.  there are no others.
--
D. Richard Hipp   <[EMAIL PROTECTED]>

[sqlite] sqlite system table names

[[EMAIL PROTECTED]]

Hi,
I want to know the names of the system tables in sqlite. I only know of the 
table sqlite_master.
Thanks in advance.
Bill