> Huang Chen Min wrote: > > Dear all: > > Forgive for asking such stupid question. I use Xbase way to > > understand SQLite. > > It is allowed to modify dat type of column in clipper. In my personal > > thoughts, Creating a brandnew table and copy those data from older version > > might be an alternative way. Is there any instrument to meet my need > > directly. > > Best Regards > > -- > > tom > > You need to study the ALTER TABLE statement and its limitations. See > http://www.sqlite.org/lang_altertable.html . >
SQLLite uses dynamic typing so you can put data of any type into any column. http://sqlite.org/faq.html#q2 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users