Adaptive Server version 15.7 ESD #2 allows you to drop columns from a table without performing a data copy.
This reduces the amount of time required for alter table drop column to run. See Adaptive Server Enterprise 15.7 ESD #2 documentation.
jConnect for JDBC, Adaptive Server Enterprise ODBC Driver, Adaptive Server Enterprise OLE DB Provider, and Adaptive Server Enterprise ADO.NET Data Provider support this feature for normal DML operations (insert, delete, update, and merge) when connected to an Adaptive Server with the feature enabled. You do not need any special configuration to use the feature; it is automatically supported.
jConnect for JDBC and Adaptive Server Enterprise ODBC Driver also support this feature for bulk copy when connected to an Adaptive Server with the feature enabled.
This feature is not available for nonmaterialized or virtual computed columns, encrypted columns, and XML Columns.