bhaskarReddy wrote:
>Is there any way to find the number of columns and column
> types in a table.
pragma table_info
--
Igor Tandetnik
___
sqlite-users mailing list
sqlite-users@sqlite.org
On Tue, 31 Jan 2012 10:34:20 +, Bart Smissaert
wrote:
>http://www.sqlite.org/faq.html#q7
>
>RBS
And this:
PRAGMA table_info(sometablename); -- returns metadata in a result set
A few coding samples:
http://www.sqlite.org/faq.html#q7
RBS
On 1/31/12, bhaskarReddy wrote:
>
> Hi Friends,
>
> Is there any way to find the number of columns and column
> types in a table.
>
>I tried with "select count(*) from tablename". But it is
> showing number
Hi Friends,
Is there any way to find the number of columns and column
types in a table.
I tried with "select count(*) from tablename". But it is
showing number of records.
Regards,
Bhaskar.
--
View this message in context:
4 matches
Mail list logo