Re: [sqlite] How to check if the column is existed in the table

Hi Joanne, On Wed, 5 Dec 2007 11:53:03 -0800 (PST), Joanne Pham <[EMAIL PROTECTED]> wrote: > Hi Kees, > Is there anyway that we can find out how > many columns are defined in the table? Interpret the results of PRAGMA table_info(tablea); or Do a SELECT * LIMIT 1 on the table and get the

Re: [sqlite] How to check if the column is existed in the table

Hi Kees, Is there anyway that we can find out how many columns are defined in the table? Thanks for the info. JP - Original Message From: Kees Nuyt <[EMAIL PROTECTED]> To: sqlite-users@sqlite.org Sent: Wednesday, December 5, 2007 10:18:48 AM Subject: Re: [sqlite] How to check

Re: [sqlite] How to check if the column is existed in the table

On Wed, 5 Dec 2007 09:56:30 -0800 (PST), Joanne Pham <[EMAIL PROTECTED]> wrote: >Hi All, >Is it possible to check if the certain column is existed in the table. >For example : I had the table as define below: > create table tablea (appid int, bytesIn int, bytesOut int) You can get information a

[sqlite] How to check if the column is existed in the table

Hi All, Is it possible to check if the certain column is existed in the table. For example : I had the table as define below: create table tablea (appid int, bytesIn int, bytesOut int) and I want to add one more column with default value of 1 and I don't want to drop the table and recreate it