Reducing the precision of a CHARACTER data type is possible without requiring a recompile. However this will cause a String Data right truncation ODBC error if the r-code tries to insert a value larger than the precision of the new column. However, reducing the precision does not cause an error for read only operations because the client code does not use precision from the r-code while retrieving records.