Re: [sqlite] How to find number of columns and types in a table.

2012-01-31 Thread Igor Tandetnik
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

Re: [sqlite] How to find number of columns and types in a table.

2012-01-31 Thread Kees Nuyt
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:

Re: [sqlite] How to find number of columns and types in a table.

2012-01-31 Thread Bart Smissaert
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

[sqlite] How to find number of columns and types in a table.

2012-01-31 Thread bhaskarReddy
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: