Re: [sqlite] how to change SQLite column definition

2007-05-29 Thread qinligeng
Thanks! But it will take a long time if the table have a large number of rows. I hope that SQLite will support "Alter Column" in next version! - Original Message - From: "Scott Hess" <[EMAIL PROTECTED]> To: Sent: Monday, May 28, 2007 10:38 PM Subject: Re: [sq

Re: [sqlite] how to change SQLite column definition

2007-05-28 Thread Scott Hess
l . So you have to do it in a bit more complicated way. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, May 28, 2007 10:50 AM To: sqlite-users@sqlite.org Subject: [sqlite] how to change SQLite column definition Is there any simple way to change the defi

RE: [sqlite] how to change SQLite column definition

2007-05-28 Thread Dennis Povshedny
: Monday, May 28, 2007 10:50 AM To: sqlite-users@sqlite.org Subject: [sqlite] how to change SQLite column definition Is there any simple way to change the definition of a column in sqlite database? we can do this in sqlserver using a sql statement like this: alter table alter column No virus

[sqlite] how to change SQLite column definition

2007-05-27 Thread qinligeng
Is there any simple way to change the definition of a column in sqlite database? we can do this in sqlserver using a sql statement like this: alter table alter column