Re: [sqlite] Adding a new field in sqlite

[Uriel_Carrasquilla]

ALTER table-name ADD COLUMN column-name TYPE ...
is not supported under SQLite.
The best approach is to create a new table with the extra column and copy
the existing table into it.

Regards,

Uriel_Carrasquilla



                                                                                
                                                       
                      "Anirban Sarkar"                                          
                                                       
                      <[EMAIL PROTECTED]        To:       
<sqlite-users@sqlite.org>                                                     
                      escltd.com>              cc:                              
                                                       
                                               Subject:  [sqlite] Adding a new 
field in sqlite                                         
                      02/03/2005 04:02                                          
                                                       
                      AM                                                        
                                                       
                      Please respond to                                         
                                                       
                      sqlite-users                                              
                                                       
                                                                                
                                                       
                                                                                
                                                       




Hi all,

I want to add a new field 'flag' to my existing table 'mri' in sqlite.
How can I do that?

Regards,
Anirban Sarkar