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

Posted in 1998

jblatz@worldnet.att.net — Fri, 25 Sep 1998 20:46:39 GMT — source: Informix-list mailing list archive (1991-1998)

In article <360A3B74.E19E7249@vbws01.ba.ford.com>, Saleem Mohammad <smohamm1@vbws01.ba.ford.com> 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. > > Thank You > Saleem > I don't know what version you are running, but it probably is the same for them all. In order to change the column width you must do an 'alter table'. This will lock that table in exclusive mode which means it cannot be accessed until the alter is complete. It will not effect the rest of the database except perhaps in terms of performance. -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum