>>I have a free table in my application in which one of the fields has to be enlarged. Is there a way programitically to, say, change the size of a text field from 25 to 50 characters ?
>>
>>Reason for asking is that this application imports data from a mainframe application and the file structure has changed - necessitating a change in size of one of the fields used to bring in and convert the data. I have to make changes to the import function and would like to programatically change the table field size if possible - and avoid having to re-distribute the table.
>>
>>Thanks.
>
>ALTER TABLE customer ALTER COLUMN cust_name C(50)
>
>Note that ALTER TABLE requires exclusive use of the table.

Thanks Nick and Mike for your responses.