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 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 about columns in a table with
PRAGMA table_info(tablea);
>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 again because I want to keep
>the data in the table.
-- rename the original table
ALTER TABLE tablea RENAME TO tablea_old;
-- create the new table
CREATE TABLE tablea (
appid int,
bytesIn int,
bytesOut int,
newcol int DEFAULT 1
);
-- Load data into the new table
INSERT INTO tablea (appid, bytesIn, bytesOut)
SELECT appid, bytesIn, bytesOut
FROM tablea_old;
-- Drop the original table
DROP TABLE tablea_old;
-- optimize the database
VACUUM;
ANALYZE;
>Thanks,
>jp
HTH
--
( Kees Nuyt
)
c[_]
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
____________________________________________________________________________________
Never miss a thing. Make Yahoo your home page.
http://www.yahoo.com/r/hs
