On Tue, Feb 28, 2012 at 7:14 AM, Marco Turco <[email protected]>wrote:
> Hi all, > > I need to alter a field from smallint(1) to smallint(2), > No you don't; not unless your application or the wrapper you are using are reading the schema or datatypes separately. SQLite itself makes no distinction between smallint(1) and smallint(2). Both operate exactly the same. > > is there to do this using ALTER TABLE ? > > > > Thanks in advance > > > > Marco > > > > > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
