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

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:

http://icculus.org/~chunky/stuff/sqlite3_example/sqlite3_example_bind.c

http://www.sqlite.org/cvstrac/wiki?p=SimpleCode


>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 of records.
>>
>>  Regards,
>> Bhaskar.
>> --
>> View this message in context:
>> http://old.nabble.com/How-to-find-number-of-columns-and-types-in-a-table.-tp33235184p33235184.html
>> Sent from the SQLite mailing list archive at Nabble.com.
>>
>> ___
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>
>___
>sqlite-users mailing list
>sqlite-users@sqlite.org
>http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

-- 
Regards,

Kees Nuyt

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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 of records.
>
>  Regards,
> Bhaskar.
> --
> View this message in context:
> http://old.nabble.com/How-to-find-number-of-columns-and-types-in-a-table.-tp33235184p33235184.html
> Sent from the SQLite mailing list archive at Nabble.com.
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[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: 
http://old.nabble.com/How-to-find-number-of-columns-and-types-in-a-table.-tp33235184p33235184.html
Sent from the SQLite mailing list archive at Nabble.com.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users