Kees Nuyt schrieb:
> On Sun, 09 May 2010 12:18:41 +0200, Oliver Lange
> <[email protected]> wrote:
> 
>> Hello,
>>
>> One thing i'm missing in PRAGMA table_info() is that i can't specify
>> a database name, like: PRAGMA table_info(main.mytable);
>>
> 
> As a workaround, you can use:
> select name from sqlite_master
>       where type='table';
> select name from sqlite_temp_master
>       where type='table';
> select name from attacheddb.sqlite_master
>       where type='table';

Thanks alot for your help, problem is solved.

-- 

Cheers,

Oliver 'Bloody' Lange.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to