alter table allows column types to be modified. With Adaptive Server version 12.5 and later, a column’s type can be modified to and from Unicode datatypes. If the command operates on a proxy table, the command is reconstructed and forwarded to the remote server that owns the actual table. If the remote server (or DirectConnect) cannot process the command, an error is expected, and the Adaptive Server command is aborted.
If trace flag 11221 is on, alter table does not get forwarded to a remote server; adding, deleting, or modifying columns is done locally on the proxy table only.
Using the alter table command, unitext can be changed to char, varchar, nchar, nvarchar, unichar, univarchar, binary, and varbinary. Any of these datatypes can be changed to unitext.
