On 09/21/2016 01:44 PM, Stepan Zakharov wrote:
Yes, of course it looks different.pragma table_info(TABLENAME);Where TABLENAME 
is my table name.I've tried it with single-quotes as well: pragma 
table_info('TABLENAME');No results in any case.And no errors. Returns 
SQLITE_OK.A very strange behaviour.

Does "PRAGMA table_info('sqlite_master');" return any results?

What does "PRAGMA compile_options;" say?

Dan.





To: sqlite-users@mailinglists.sqlite.org
From: clem...@ladisch.de
Date: Wed, 21 Sep 2016 08:27:32 +0200
Subject: Re: [sqlite] A problem with 'pragma table_info(...)'

Stepan Zakharov wrote:
it does not return any results
That is because the table name is not correctly quoted:

   sqlite> pragma table_info(...);
   Error: near ".": syntax error

Or does your statement look different?


Regards,
Clemens
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
                                        
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to