AFAIK SQLite does not have such functionality. Please see http://sqlite.org/lang_altertable.html . So you have to do it in a bit more complicated way.
Regards, Dennis Xeepe Phone Solution Team http://xeepe.com -----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 definition of a column in sqlite database? we can do this in sqlserver using a sql statement like this: alter table <tablename> alter column <column definition>.... No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.467 / Virus Database: 269.7.6/815 - Release Date: 22.05.2007 15:49 ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
