modifying field types Smallint to integers

There should be no loss of data, since you are going to a larger field. You will see an increase in size of the overall data file, and index file if the field_name is part of an index. Also note (at least in my version of Informix) that Informix accomplishes an "ALTER TABLE" command by creating a NEW table, and then copying the data from the old table to the new table VP > -----Original Message----- > From: judah [SMTP:judah@pagetalk.com] > Posted At: Thursday, April 15, 1999 5:38 PM > Posted To: informix > Conversation: modifying field types Smallint to integers > Subject: Re: modifying field types Smallint to integers > > > judah wrote: > ALTER TABLE table_name > MODIFY (field_name INTEGER NOT NULL)> > does anyone know the implications of changing from a smallint to an > int? > > Judah > >