Re: alter a row type ?

Hi Currently, there is no support to alter a row type. A named row type, once created, is static. The only concept of "altering" a named row type is by subtyping (ie. using the "under" keyword to create a subtype), but even with subtyping, the fields of the supertype can not be "alter" by the subtype, it is inherited as is. Thanks. Davis W. Kwong Floyd Wellershaus <fwellers@yahoo.c om> To Sent by: informix-list@iiug.org owner-informix-li cc st@iiug.org Subject alter a row type ? 11/14/2005 11:56 AM Hello, A client has a row type, and 3 tables "under" that type. I need to alter ( lengthen some fields in those tables ). How do I do this ? Do I somehow alter the row type and the other children tables will be altered automatically ? What about indexes that were created on those fields ? Thanks much. Floyd sending to informix-list [demime 1.01d removed an attachment of type image/gif which had a name of graycol.gif] [demime 1.01d removed an attachment of type image/gif which had a name of pic19318.gif] [demime 1.01d removed an attachment of type image/gif which had a name of ecblank.gif] sending to informix-list