3810777 - Error "Msg 155: 'COMPRESSION' is not a recognized CREATE INDEX option" when trying to recreate a compressed nonclustered index in SAP ASE

• After a compressed nonclustered index is dropped, attempting to recreate it using SQL Server–style syntax fails with:

Msg 155, Level 15, State 17:
Server 'EVP', Line 1:
'COMPRESSION' is not a recognized CREATE INDEX option.

• Example command
  CREATE NONCLUSTERED INDEX ZARCH_ID ON SAPSR3.GRACFFREPMAPP (ACTION_ID)
  WITH COMPRESSION = PAGE
  go

• SAP Adaptive Server Enterprise (ASE) 16.0 and higher
• SAP Business suite

ASE, Adaptive Server Enterprise, create index, COMPRESSION option, Msg 155, Level 15, State 17, page compression, table-level compression, sp_help, sp_helpindex, nonclustered index, index compressed, inherit compression, syntax error , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem