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 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.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users