Use alter table on Remote Tables

You can use alter table to modify a remote table using Component Integration Services (CIS).

Before you modify a remote table, make sure that CIS is running by entering:
sp_configure "enable cis"

If CIS is enabled, the output of this command is “1.” By default, CIS is enabled when you install SAP ASE.

See, Setting Configuration Parameters, in the System Administration Guide: Volume 1, and the Component Integration Services Users Guide.