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'