Re: [sqlite] PRAGMA table_info(second.table)

You should look more closely at the syntax for the Pragma statement. What you need is: PRAGMA test.table_info(tab1); This makes sense when you consider not all pragmas have arguments. Peter On 6/4/2014 11:19 PM, LacaK wrote: Hi, when I attach database using f.e ATTACH DATABASE 'test.db' AS

Re: [sqlite] PRAGMA table_info(second.table)

On 6/5/2014 2:19 AM, LacaK wrote: Then when I try PRAGMA table_info(test.tab1) , I get error: near ".": syntax error. The correct syntax is PRAGMA test.table_info(tab1) ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] PRAGMA table_info(second.table)

Hi, when I attach database using f.e ATTACH DATABASE 'test.db' AS tets; and in attached database is f.e. table "tab1". Then when I try PRAGMA table_info(test.tab1) , I get error: near ".": syntax error. Is it expected ? (of course SELECT * FROM test.tab1 works as expected ...) Thanks -Laco.