Re: Can we change the column width of a column in a live database?

Saleem Mohammad wrote: > > Hi Everyone > > Can we change the ( I have to increase the width of character > filed in a table of a live database) width of a column in a > live database??? Please let me know. Yes no problem in Informix. Assume the column, named family in table people, is 10 characters and you need it to be 20: alter table people modify family char(20); or for two or more columns: alter table people modify (family char(20), surname char(20)); Done with no data loss. Art S. Kagel