2348588 - Error 1790 raised when trying to compress table with user defined datatypes - SAP ASE

• ALTER TABLE SET COMPRESSION raises error 1790
• The table contains columns declared as user-defined datatypes

Example:

Msg 1790, Level 16, State 2:
Server 'sybase', Line 2:
Table 't1' cannot be compressed; none of the columns are compressible.

SAP Adaptive Server Enterprise, all versions

error 1790, table compression issue, user defined datatypes, ALTER TABLE compression, CR 800691, workaround for table compression, datatype modification, page compression error, column compression issue, database troubleshooting, database compression failure, user defined datatype error, column datatype modification, page compression troubleshooting, CR 800691, database error resolution, column compression workaround, database environment troubleshooting , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Known Error